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%5B/quote%5D

[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]