• Loading flat file into a database table with SSIS

    Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...

    ITKE350,945 pointsBadges:
  • Merging columns in SQL Server database

    Hi everyone! In my SQL Server database, I'm trying to merge the following: [TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine Into this: [TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 Elaine Now, I know there's the function "GROUP_CONCAT" for MySQL...

    ITKE350,945 pointsBadges:
  • Administrator privileges in SQL Server 2008

    I recently installed SQL Server 2008 R2 onto my local machine. However, I can't create a new database because I'm getting the following message:CREATE DATABASE PERMISSION DENIEDAfter I saw that message, I tried to switch my administrator privileges but I received this:"User does not have permission...

    ITKE350,945 pointsBadges:
  • Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE350,945 pointsBadges:
  • Connecting a SQL Server database with Visual Basic 6.0

    What code would I need to connect a SQL Server database with Visual Basic 6?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to use SQL Server 2005

    I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.

    Anand79865 pointsBadges:
  • Connecting a SQL Server database with Visual C++ and .NET

    How can I connect a SQL Server database with Visual C++ and .NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Accessing another database using a variable

    I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't...

    CO Bill120 pointsBadges:
  • Passing data between two databases in SQL Server

    Is it possible to have a stored procedure in a SQL Server database look at tables in another SQL Server database by sending the second database name as a parameter to the stored procedure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Authenticated user change his/her own password

    We have an Access application that leverages ODBC DSN to link to SQL Server 2008 database. SQL Authenticated logins and passwords have been created for each user on the SQL Server, these logins have been granted access to the SQL Server database. When creating the logins: Enforce password policy,...

    TLMercer45 pointsBadges:
  • How to retrieve tables?

    My SQL Server 2005 database get corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

    DatabaseRecovery35 pointsBadges:
  • Database Recreate

    My SQL server 2000 Database is corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

    DatabaseRecovery35 pointsBadges:
  • Recovering .mdf and .ldf files from SQL Server

    I backed-up our SQL Server yesterday around noon, and we then added more data in. Today, when we tried to start our application, we found that the database is in SUSPEND mode. We stopped our SQL services and tried to copy the newer data, but there was a data error. It seems that our .mdf file is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring a SQL database with an .mdf file

    How can I restore a SQL database with an .mdf file?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Load balance of SQL database

    When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?

    RASHMIMB15 pointsBadges:
  • SQL database design

    i have slary system using vb.net  and sql server there is  27 user the compute up to  700 employ salary every monthe i collecte (700 *27) number of row and adding them programaticaly to a table called salary the table salary have 40 column with one primery key  is there any proplem with this...

    msmj8675 pointsBadges:
  • Use of database backup from lower version to higher version of sqlserver

    I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup  into  sqlserver 2008

    Vineet2820 pointsBadges:
  • SQL Server 2008 Restore Fails – There is insufficient system memory in resource pool ‘internal’ to run this query

    I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error. 100 percent processed. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 701, Level 17, State 123, Line 1 There is...

    MTLONDON20 pointsBadges:
  • SQL Server 2005 backup server

    Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

    NewnanIT1,110 pointsBadges:
  • Database Views in SQL Server

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.

    Jwcurrier30 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following