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 |
|
davy_boy2000
Starting Member
28 Posts |
 Posted - 2002-07-31 : 07:36:35
|
| Hi Folks,I have a 2000 remote server that polls the 6.5 server every 2 mins to check for access violation on the server via a query analyzer connection. It then uses xp_sendamil and net send for notifications.The problem is, I've started to get loads of orphan connections from the remote server, which will not kill when attempted.Any ideas, apart from stopping and starting sql service? |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-31 : 11:31:19
|
| How are you autimating a Query Analyzer Connection? QA is a tool that I didn't know was scriptable?Jay White{0} |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-31 : 12:43:31
|
| For one of these processes that won't die,get the spid from sp_who2 and then run dbcc inputbuffer(spid) in a QA session connected to the server and see what the last command was. If it's calling an xp you cannot kill it from within TSQL using the kill command because its an external process.HTHJasper Smith |
|
|
|
|
|
|
Orphan's won't die...