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 |
|
X002548
Not Just a Number
15586 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-21 : 15:47:21
|
| What did it say if you tried to kill it again?Was the session blocked by anything?--Gail ShawSQL Server MVP |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2011-12-21 : 15:56:19
|
quote:
Originally posted by GilaMonster
What did it say if you tried to kill it again?Was the session blocked by anything?--Gail ShawSQL Server MVP
It was doing the blocking..this freakin server is like the wild westOur area was split up into 3...and everyone wants to be a (pretend) dbaa little knowledge is a dangerous thing?One day I found that someone had shut down the agentanother day some bozo was setting up replication...because they wanted to learn....all hell broke loose...got my baqckupsI need my own dev boxBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/ |
|
|
|
|
|
|
Kill SPID