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 |
|
kieran5405
Yak Posting Veteran
96 Posts |
 Posted - 2009-04-21 : 12:27:20
|
| Hi,I using Sql Server 2005 on a hosted website. This means I dont have access to run commands like sp_who.However I am having a problem with open connections. Is there any other way to see what connections are open on my DB i.e. some system table that I can run my DB name against maybe to pull back open connections?? etc..Thanks for all help... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 12:48:45
|
| The connections are in master..sysprocesses (or sys.dm_exec_connections for the youngsters).But you probably won't have access to master either.Unfortunately unless the spid id executing something it won't appear in the database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Sp_who on hosted Sql Server DB