no.of.user connections? RRS feed

  • Question

  • How to find out how many no.of. users are connected to my sql server? 

    How to set default no.of.user connections to sql server?

    Friday, December 24, 2010 5:34 AM



    select * from sys.dm_exec_connections  should give you a list of active connections to the sql server.


    You cannot set the default no of users. why do you need to set that?

    Snehadeep(MSFT) SQL Developer Team
    • Marked as answer by Jackie-Sun Monday, December 27, 2010 10:16 AM
    Friday, December 24, 2010 10:59 AM