October 26, 2012 at 9:55 am
Hi ,
While running some transaction i got blocked by spid -2 and i'm not sure what it is..
We are trying to delete a table and reseed the identity column of that table and load data into that table as part of one tarnsaction..and we got that lock at that time..
So i was wondering what exactly was spid -2 ..i tried to find it out but wasn't successfull..
Can some one help me out in understanding what is meant by that please.
Thank you so much
October 26, 2012 at 1:29 pm
Try this article
http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply