July 2, 2008 at 10:43 pm
Sql server data base generating session id in negative value like -1,-2 .could you explain ?
July 3, 2008 at 1:32 am
sudhakara (7/2/2008)
Sql server data base generating session id in negative value like -1,-2 .could you explain ?
Orphaned transactions get a session id of -2. Most common reason is DTC. If you need to kill it you can use the kill statement, but instead of specifying the spid, use UOW (unit of work). For more info see Books Online http://msdn.microsoft.com/en-us/library/ms173730.aspx
Regards,
Andras
July 3, 2008 at 1:34 am
These are orphaned sessions and you should kill them. Unfortunately you can't kill them the easy way by running Kill -2 ,but you need to find the Unit of Work ID from the syslockinfo table. You can find more info here http://technet.microsoft.com/en-us/library/aa275788(SQL.80).aspx and here http://msdn.microsoft.com/en-us/library/aa933230(SQL.80).aspx
[font="Verdana"]Markus Bohse[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply