Before creating and executing sp_resetstatus, note the following:
Create sp_resetstatus in the master database.
You must have sa_role to execute this procedure.
Since this procedure modifies the system catalog, you must enable updates to the catalog before executing the procedure. Use the procedure below to enable updates:
1> use master 2> go
1> sp_configure "allow updates", 1 2> go
If you change the name of the procedure, make sure the new procedure name begins with “sp_”.
Review the Transact-SQL User's Guide explanation of how to create and execute stored procedures.
