November 7, 2007 at 11:52 am
Hi How do I determine the number of concurrent connections on a database
November 7, 2007 at 11:54 am
sp_who2 will show all current connections to a SQL Server instance. Is this what you are looking for?
November 7, 2007 at 12:15 pm
November 7, 2007 at 12:16 pm
Thanks for the reply. I would like to get a query for the same.. Need to get this value in my application
Wisenut
November 7, 2007 at 12:47 pm
Take a look at this one, use the same method to query the DMV's in order to get what your looking for.
http://sqlserver2005.databases.aspfaq.com/better-sp-who2.html
Tommy
Follow @sqlscribeViewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply