Zapuskau:

USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_resetstatus 'sysnet5'
GO
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO


Vidaet soobshenie:
<<<
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
Prior to updating sysdatabases entry for database 'sysnet5', mode = 0 and status = 4194317 (status suspect_bit = 0).
No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.>>>

A baza visit "SUSPENDED/Loading" (otmenili "RESTORE" operaciu i ona zavisla)
Pomogite: u nas MSSQL200 i DB fili na udalinnom servere(esli eto vazno).

V BOL est code dlia sozdania proceduri sp_resetstatus.
No v masters uze est takaia procedura i code u nih raznii.
Zapustila tu kotoraia v BOL i ona mne vidala " Eta procedura rabotaet tolko esli DB Suspended"
No u menia-ze on i est SUSPENDED!!!

V tablice sysdatabase status=32, a vot MODE u vseh DB =0, a u etoi =51.
Mozet v etom delo?

Posle ostanovki i perezapuska servera v EM visit kak "SUSPENDED",
a iz tablic v MASTERS ischezla, i ia teper voobshe ne mogu nichego s nei sdelat.

POMOGITE!!!!!!!