Post reply

Which mode my SQL Server is running???

  • July 1, 2009 at 4:46 pm

    #132371

    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.

  • July 1, 2009 at 5:01 pm

    #1018798

    mahesh.vsp (7/1/2009)

    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.

    Here is the query to find out what you are looking for.

    select serverproperty('IsSingleUser ')

  • July 1, 2009 at 5:30 pm

    #1018816

    Thanks Kalyani!

  • July 1, 2009 at 7:00 pm

    #1018836

    Do you use single user very often? IT is something that I admit I would be unlikely to check for. I would think long and hard before I got myself into a situation where this was relevant..

    CEWII

  • July 1, 2009 at 11:27 pm

    #1018896

    Hi, That's just my curiosity!

    I am new to SQL Server 2005 and Administration.

    The Question was struck in my mind and that's how!!!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply