The commands to create a procedure called sp_resetstatus, which turns off the “suspect” flag on a database while leaving all other database options intact, are shown below. This is the safest method. An alternative approach using Transact-SQL commands is also presented.
Reset a database's “suspect” status only when instructed in this manual or by Sybase Technical Support. Otherwise, you may damage your database.
WARNING! The sp_resetstatus stored procedure is provided for your information-it is not supported at this time.
