I have limited access to this server eg I cannot SELECT * FROM sys.dm_tran_session_transactions for example
I, perhaps foolishly, ran this query to insert some test data...
begin transaction
update aqt_tblquote
set intVisits = ABS(CHECKSUM(NewId())) % 10
select top 100 intVisits FROM aqt_tblquote
rollback transaction
This sat about for a while and then informed me the log was full. From my experience this is not good news!
I was hoping that given it is in a ROLLBACK that it would just return the table to its previous state and clear the log.
However if I select from sys.databases I get log_reuse_wait_desc = 'ACTIVE_TRANSACTION'
I've closed Management Studio but that didn't do it. How can I kill it? Or do I need to contact the virtually unobtainable DBAs? (I work in a large organisation where there are many layers of bureaucracy to cut through).
