A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server: "You can use the DBCC OPENTRAN Transact-SQL reference to verify if there is an active transaction in a database at a particular time"