Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    41

    Unanswered: Which mode SQL Server is running???

    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.

  2. #2
    Join Date
    Jun 2009
    Posts
    26
    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.

  3. #3
    Join Date
    Jun 2009
    Posts
    26
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •