sqlserver database suspect

  • Thread starter Thread starter Selen
  • Start date Start date
S

Selen

Hello,
I am using xp.and my user was deleted. I create new user.But now my database
seem suspect.How can I get back my database

Thanks..
 
In sql 2000: sp_resetstatus 'database name

you need to be an admin.

In SQL 7 there is a stored proc. You need to build it yourself. The code can be found in the books online
 
Back
Top