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

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts