How to repair Suspect data of SQL server 2000 [Resolved]

Posted by Aspbimal under Sql Server on 6/14/2011 | Points: 10 | Views : 196174 | Status : [Member] | Replies : 1
Hi

I have a Sql database applicaation, and while opening this database through SQl 2000 server it show SUSPECT message under bracket. How
can we repair suspect data of SQl server 2000




Responses

Posted by: Prabhakar on: 6/14/2011 [Member] [MVP] Starter | Points: 50

Up
0
Down

Resolved
Helllo Aspbimal


Try this step and ur data base working on . . write on query analyzer .


Step1-----------

Sp_configure 'allow updates', 1
Reconfigure with override


Step2------------
update sysdatabases
set status = status | -32768
where name = 'APH'

APH here data base name . .



Best Regard's
Prabhakar

Aspbimal, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response