This question already has an answer here:
- how to repair suspect db 2 answers
I am trying to repair a suspect database. The problem is that when I run:
EXEC sp_resetstatus property;
I get this response:
Warning: You must recover this database prior to access.
when I try this:
ALTER DATABASE property SET EMERGENCY;
it also fails:
Msg 5011, Level 14, State 7, Line 1
User does not have permission to alter database 'property', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
What do I do next?