July 12, 2012 at 10:28 pm
Comments posted to this topic are about the item Kill a SPID
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 13, 2012 at 2:23 am
Most normally I use kill restoring a staging database or similar when some slack alice developer has left open a dead connection from Visual Studio or perhaps SSMS or somesuch. I make no apologies on that one! Production is obviously a different matter...
July 13, 2012 at 4:53 am
Kill them all and let Codd sort them out.
July 13, 2012 at 5:47 am
Am I the only one who saw the title of this article and thought it was referring to the Katy Perry song - "I killed a PID and I liked it..."
July 13, 2012 at 6:09 am
Chris Houghton (7/13/2012)
Kill them all and let Codd sort them out.
:hehe:
July 13, 2012 at 7:22 am
Steve says: Lie down on zee couch. What seems to be the problem?
DBA: "I've got a small situation here."
Steve says: Small man complex?
DBA: "I've got a SPID that don't want to die."
Steve says: Is your name Kevorkian?
DBA: "I've noticed this SPID this morning, and noticed that it was started about 3 day ago."
Steve says: Have you been using Acid, you are very perceptive?
DBA: "But I can't see what command was passed to xp_cmdshell."
Steve says: Does not knowing make you feel depressed?
DBA: "We're running SQL server 2000 SP4."
Steve says: How was your relationship with your mother?
July 13, 2012 at 7:26 am
A thread five years old is considered recent? :blink:
July 13, 2012 at 8:25 am
When we tell the user community repeatedly to be out of the database by 6PM sharp during critical upgrades or maintenance windows, we mean it.:-D They have found out the hard way many times.
"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
July 16, 2012 at 5:01 pm
"Kill it before it grows" E Clapton
Not all gray hairs are Dinosaurs!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply