Have you tried sp_resetstatus?
You'll have to create it.
here it is. <<reset_status.sql>>

-----Original Message-----
From: Shawn Smith (William) [mailto:[Email Address Removed]
Sent: Thursday, March 14, 2002 6:36 AM
To: '[Email Address Removed] '[Email Address Removed] DB Suspect

I had a server crash and now one of my production databases is "suspect".
Are there any tools I can run that will fix this without restoring the
Database?

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page