suspect db 1

[lyudmila]

Is this syntax does not work on SQL SERVER 2000 for suspect database. I used it couple times on older versions of SQL.
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES', 1
GO
RECONFIGURE
GO
update master..sysdatabases set status='256'
where name='MY DB'
SP_CONFIGURE 'ALLOW UPDATES', 0
GO
RECONFIGURE WITH OVERRIDE
GO

 

[tlbroadbent]

Try executing sp_resetstatus. It is documented in SQL BOL.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ra-rz_9go9.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.