sys.sp_resetstatus
general #stored-procedure
Description
Resets the status of a suspect database.
Syntax
sp_resetstatus [ @
DBN ame = ]
N
'DBName'
[ ; ]Remarks
Resets the status of a suspect database.
The name of the database to reset.
, with no default.
(success) or
turns off the suspect flag on a database. This procedure updates the mode and
status columns of the named database in. The SQL Server error log should be
consulted and all problems resolved before running this procedure. Stop and restart the
instance of SQL Server after you execute
This feature will be removed in a future version of SQL Server. Avoid using this feature in
new development work, and plan to modify applications that currently use this feature.
Examples
Example 1
AdventureWorks2022
Example 2
EXECUTE sp_resetstatus
'AdventureWorks2022'
;