• Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Error inserting into table with identity column

    I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I'm not). Here is the code from the 2...

    Bleeb45 pointsBadges:
  • row_number in SQL 2000

    How do I find out the row_number in SQL 2000 like using row_number() function in SQL 2005?

    Rl10 pointsBadges:
  • Truncating the transaction log for a SQL Server 2000 database

    What is the best automated way to truncate the transaction log for a SQL Server 2000 database?

    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:
  • restore deleted table

    1. How can you restore a table that was accidentally deleted by not performing a full database restore in SQL SERVER? 2. Can you track the machine who deleted that table?

    Razorgrip0 pointsBadges:
  • Restoring a deleted table in SQL Server 2005

    How do I restore a deleted table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • How to read a table in SQL database

    How can I read a table in a SQL database?

    vSphereadmin5 pointsBadges:
  • MS SQL Server 2000 Vulnerability

    Hello, I have installed on one of my servers SQL Server 8.00.2273 - SP4 (Standard Edition). At the last vulnerability tests it founds the followings: 1. Microsoft SQL Server MTF Data Structures Memory Corruption Vulnerability (MS08-040) 2. Microsoft SQL Server 'sp_replwritetovarbin' Remote Memory...

    MariusRO15 pointsBadges:
  • Stored Procedures in SQL Server 2005

    Will you please explain me about Stored Procedures in SQL Server 2005?

    Rajanarina110 pointsBadges:
  • What is SQL Azure?

    Sorry for this dummy question, what is SQL Azure?

    ITKE434,705 pointsBadges:
  • How to select 1 record in DB2

    As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

    Linhntk5 pointsBadges:
  • Encryption Form SQL Server 2000

    I want to transfer data from one database to another database both the databases are on SQL Server 2000. I want to transfer the data in encryption form. How do I do it? Regards, Sahil

    Maruf245 pointsBadges:
  • MS SQL SERVER (BKUPEXEC) Services wont start

    Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL...

    Ahmyown30 pointsBadges:
  • Transfering table data from one database to another

    I am using SQL Server 2005 i m inserting some data from one database to another. both Servers are resided on different machine.

    Pankaja5 pointsBadges:
  • Duplicate SQL Server 2005 database

    What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human...

    ITKE434,705 pointsBadges:
  • Avoid duplicate entry in database through Visual Basic 2005

    I have made a program in VB 2005 with SQL 2005 as back end. In the data base there are three fields which are unique id of a person. I want to display "Already Exist" message box when I enter an already existing id. matching all three fields and not allow duplicate entry.

    Sukas10 pointsBadges:
  • Storing and retrieving an image in SQL Server 2000

    How do I store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Memory could not be written

    I keep getting the following error when I try to Close/Modify the DTS package or close the SQL 2000 (by x-out) on the remote workstation which has Windows XP OS. Application popup: mmc.exe - Application Error : The instruction at "0x4173d22a" referenced memory at "0x02241e90". The memory could not...

    Bjet55 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.

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

Following