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
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?