there is always something to develop
How to get list of opened connections to current database
To get list of active connections to current database use the query
SELECT nt_domain, nt_username, hostname, loginame, cmd FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE dbid = DB_ID(db_name())
Comments
"We rarely think people have good sense unless they agree with us."
You are 5573 reader
since 1st April 2009
Yes | 0 | |
No | 0 |