Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2009-07-01 : 18:44:36
|
| Hi Everyone,After connecting to the instance, as a user/ developer can i know in which mode my SQL Server is running (i.e MULTI_USER mode or Single user mode). Is there any query to get this information.Any help would be greatly appreciated.Thank You. |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-02 : 03:45:56
|
| SELECT SERVERPROPERTY('ISSINGLEUSER')The server is in single user mode. 1 = Single User.0 = Not Single UserNULL = Invalid input, or error.Base data type: int |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-02 : 18:40:39
|
| It will mark in your databases if you are using other than multi-user mode. |
|
|
|
|
|
|
Which mode SQL Server is running ?