Run recovery by executing DBCC DBRECOVER (database).

Add a log file to the suspect database and run recovery on the database by executing sp_add_log_file_recover_suspect_db.

(1)Check in the New Database if that table got created,If yes delete it and try again as DTS might got failed in between.

(2)Try again  Dts.

(3)If it fails again try use...

Any one got a simple and easy web link or Article for the Bulk Copy Utilty.Need to have simple Examples and easy for referance when needed .

Procedure to Reset Status of Databases Marked Suspect

Operating System/Software Version: SQL 6.5 and 7.0

Overview: This article presents the procedure to reset the status of databases marked suspect.

When SQL Server starts...

 steve ,

 In my post i also wrote that it got fixed as per

FINALLY

dropped database xyz and recreated /Ran dts - transferred old xyz to the

newly created xyz Detached old...