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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2006-05-09 : 02:29:52
|
| Hi,when I start a new trace using profiler with the default template I get a bunch of "Existing connection"'s. These are from some problems I had with some distributed transactions a few days back. But the problem is that these connections wount go away... I have tried to kill the spids but without luck. Right now there are 88 of them and I'd like to remove them...they have been there for quite some time now. Any ideas?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-09 : 02:34:07
|
| restart the services? if they come back in then delete the logins?--------------------keeping it simple... |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-05-09 : 02:40:24
|
| Hm, just restart the sql server service? Will that reset all the connections?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-09 : 03:04:52
|
| it will disconnect all connections to the sql server--------------------keeping it simple... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-05-09 : 03:16:18
|
Ok, cool! thanx  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
Profiler existing connections