More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What stored procedure you can execute to find out if a database is set to single-user or multi-user mode?
You can use the "sp_helpdb" to find out this. It will return the current setting as part of the "status" value.
For example: "Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=706,
Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled
(Continued on next question...)
