Alternative Method of Resetting a Database's “suspect” Status

The sp_resetstatus stored procedure is the safest method for resetting the suspect status of a database.

Use the following procedure on the suspect database:
```
1> sp_configure "allow updates", 1
2> go
```
```
1> use master 
2> go
```
```
1> begin transaction
2> go
```
```
1> update sysdatabases 
2> set status = status & ~256
3> where name="database_name"
4> go
```
If only one row is affected by the update transaction, continue with these instructions. If more than one row is affected by the update transaction, roll back the transaction and find out why other rows are being affected.
If the above commands affect only one row, use the commands below to commit the transaction, disable updates to the system tables, issue a checkpoint, and shut down Adaptive Server:
```
1> commit transaction
2> go
```
```
1> sp_configure "allow updates", 0
2> go
```
```
1> checkpoint
2> go
```
```
1> shutdown
2> go
```
Start Adaptive Server.