Max number of user connections available...

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  July 10, 2012 at 6:23 am

  #259186

  hi,

  Can anyone please advise, what are the maximum number of user connections allowed in each different instance of SQL Server (2000, 2005 and 2008) ?

  Thanks.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  July 10, 2012 at 6:30 am

  #1510863

  select @@max_connections

  sp_configure 'user connections'