codebrothers.net :: Home  >  Matthias Denkmaier
User: Guest  Login
Matthias Denkmaier
C# - what else?
Blog search:  
How to get current SQL connections

A frequently asked question is how to get currently opened and used connections on a SQL Server.

The easiest way is to use one of the SQL Server managed views to select all open connections:

select * from sys.dm_exec_connections

Share this post: Email it!
Posted:  2/4/2007 1:04:51 PM  by  mdenkmaier
Tags:  SQLDevelopment
No comments, yet!
Leave a Comment

Name required

Your URL

Comments (required)