CREATE PROC sp_resetstatus @dbname varchar(30)AS
DECLARE @msg varchar(80)
IF @@trancount > 0
BEGIN
PRINT "Can't run sp_resetstatus fromwithin a transaction."
RETURN (1)
END
IF suser_id() != 1
BEGIN
SELECT @msg
= "You must be the System Administrator (SA)"
SELECT @msg = @msg + " to execute this procedure."
PRINT @msg
RETURN (1)
END
IF (SELECT COUNT(*) FROM master..sysdatabases
WHERE name = @dbname) != 1
BEGIN
SEL
ECT @msg = "Database '" + @dbname + "' does not exist!"
PRINT @msg
RETURN (1)
END
IF (SELECT COUNT(*) FROM master..sysdatabases
WHERE name = @dbname AND status & 256 = 256) != 1
BEGIN
PRINT "sp_resetstatus may onl
y be run on suspectdatabases."
RETURN (1)
END
BEGIN TRAN
UPDATE master..sysdatabases
SET status = status - 320
WHERE name = @dbname
IF @@error != 0 OR @@rowcount != 1
ROLLBACK TRAN
ELSE
BEGIN

COMMIT TRAN
SELECT @msg = "Database '" + @dbname + "' statusreset!"
PRINT @msg
PRINT " "
PRINT "WARNING: You must reboot Adaptive Server prior to "
PRINT " accessing this database!"

PRINT" "
END

sp_resetstatus <Имя БД которая в суспекте>