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
    Friday, December 24, 2010 10:59 AM