How to set a database in emergency mode?

Question

my database is stoped. i can't make anything, select, update, nothing. somebody told me to set the database in emergency mode but i don't know how?

Answer 1

i think this is only for Server DB, or not?

in SQL Documentation was a query like this:

set emergency mode "databasename"

try it on! cos' I have only Express Edition of SQL Server here

Answer 2

i found the solution : ALTER DATABASE dbName SET Emergency