Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-18 : 08:36:12
|
| Raja writes "Hi,1) How can I display the total of opened connections.There is a procedure (sp_monitor) that shows the connections since the last time the server has started. But it shows all the connections. opened and closed. what I want is the number of connections that were left opened. Is there any problem about opening connections and forget to close them? Does de server loose performance?" |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-01-19 : 01:29:27
|
| select * from sysprocesses where open_tran <> 0DBCC OPENTRANMohammedU |
 |
|
|
|
|
|
Opened connections on sql server 2000