SQL Server Tag Directory

Browse Alphabetically:

Featured SQL Server Questions

  • Re-linking SQL Server database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 pointsBadges:
  • Need to create SQL DTS Package

    We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also, I want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script?

    JimmyIT1,725 pointsBadges:
  • How to Schedule jobs in DTS in sql server 2000

    I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

    SRI HARSHA10 pointsBadges:
  • Troubleshooting a DTS job failure on SQL Server

    I have a DTS job that failed on my SQL Server, but it doesn't have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring Database

    I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

    Tyecom5 pointsBadges:
  • Calling an Oracle stored procedure in SQL Server

    I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

    SQL Server Ask the Experts2,585 pointsBadges:
  • combo box in dbgrid

    I want to drop combo box in dbgrid. How to do it?

    Sysmatics25 pointsBadges:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • Copying a database to a newer version of SQL Server

    I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my problem. Is this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • coloring rows “if” true

    I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...

    Tstychalski5 pointsBadges:
  • Database file in Novell GroupWise

    What is a data base file in novell groupwise? Is it associated with each novell file or there is only 1 which contains info for all other file?

    PCVITA15 pointsBadges:
  • How to repair backup of .mdf file database?

    One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...

    jordan26henderson5 pointsBadges:
  • SQL database recovery from corrupt database file!

    Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes...

    chengchong365 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • How to open .db files with Excel

    Hi, how to config Excel to allow opening of .db files?

    cfs0105 pointsBadges:
  • BCP utility in SQL Server 2005

    Hi, how to send logins from server to another server using BCP utility?

    241219840 pointsBadges:
  • How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005

    Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard". Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I...

    Pjunk5 pointsBadges:
  • Error message in the Copy Database Wizard in SQL Server 2005

    I am attempting to make a copy of a database using the Copy Database Wizard in SQL Server 2005, but I am receiving the following error: TITLE: Copy Database Wizard ------------------------------: The action you attempted to perform on a remote SQL Server instance failed because the action requires...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 ‘alter user’

    Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domain\login_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. I know this method exist in SQL Server 2005, are any of you able...

    Db23290 pointsBadges:
  • How to restore Sql Server 2000 mdf and ldf data

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

    Databaseserver20 pointsBadges:

Browse Alphabetically:

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