| List connections on sql server 2008 |
| Sunday, 13 December 2009 | |
|
How do I list all of the connections or view the total connections in use on SQL Server 2008 The answer is in this little script SELECT DB_NAME(dbid) as 'Database Name', COUNT(dbid) as 'Total Connections' FROM sys.sysprocesses WITH (nolock) WHERE dbid > 0 GROUP BY dbid Thanks for http://www.sqldba.org/.../18-view-database-connections-in-sql-server.aspx Its a life saver |