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.

Not sure if you can check it via a query but the easiest way is to find out is to open SQL Server Management Studio and connect to your server / instance. If a database is in single user mode it will have "Single User" in brackets after the database name.

You got me curious so I did a search... it's actually pretty easy. You need to use the DATABASEPROPERTYEX statement... so run this SQL:

select DATABASEPROPERTYEX ('yourdatabasenamehere', 'useraccess')

and it will return either multi_user or single_user