Matt Miller (#4) (11/7/2007)
Two things to check. One is that you might have the "implicit transaction" setting turned on, which means EVERYTHING it wrapped in a transaction. Check the properties of the server/database.Otherwise, you can use the DBCC OPENTRAN function to find any uncommitted transactions....
Syntax is here: http://msdn2.microsoft.com/en-us/library/ms182792.aspx
[font="Verdana"]But DB is in unstable state, as for my example i have transacted over 2 tables but accidentally the SQL connection was closed.
How to get rid of uncommitted transaction!
Should kill the process from sysprocess?
Thank u?
[/font]