Databade Suspect

Hi ,
I need help , As I have mssql server with the database . Now I can not
access to this Database because the data have the suspect . How can I
Resetting the Suspect ?
Thanks and regards ,
ChuongTrang
UPDATE master..sysdatabases SET status = status^256 WHERE name = <dbname>
If the database still goes back into suspect mode, and you can't fix the
original problem, and you have no recent backup, then you can get
information out of the database by putting it into emergency mode. If you
do this, extract the data/objects out with BCP/Transfer Manager and then
rebuild the database. Note that the data may be corrupt or transactionally
inconsistent.
Issue the following command to put the database into emergency mode (you'll
need to allow updates first)
UPDATE master..sysdatabases SET status=-32768 WHERE name='<dbname>'
"Trang" <trangtran86@.hotmail.com> wrote in message
news:Oz9Ua24dDHA.3660@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> I need help , As I have mssql server with the database . Now I can not
> access to this Database because the data have the suspect . How can I
> Resetting the Suspect ?
> Thanks and regards ,
> Chuong
>