The commands to create a procedure called sp_marksuspect, which turns on the suspect status bit on the specified database, are described in the stored procedure code below.
Use sp_marksuspect to prepare a damaged database that is to be dropped with dbcc dbrepair.
WARNING! The sp_marksuspect stored procedure is provided for your information-it is not supported at this time.
