Hi:
I tried to restore a database and get 'suspect' gray sign on it and found in the error.log of "Bypassing recovery for database 'DBxyz' because it is marked IN LOAD."

Then, I tried the following T/sql:
sp_resetstatus DBxyz

and got following response from exec:
Prior to updating sysdatabases entry for database 'DBxyz', mode = 0 and status = 4194361 (status suspect_bit = 0).
No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.

after I drop it, and restore again, it works. I remember that sp_resetstatus worked fine in the SQL6.5, but not so in sql2000....

thanks
David