John W. Colby
jwcolby at colbyconsulting.com
Tue Nov 2 00:54:04 CST 2004
Never mind. When I tried to close QA it told me I had unfinished transactions. When I said yes, execute them it released the records. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Tuesday, November 02, 2004 1:26 AM To: SQLServer Subject: [dba-SQLServer] Undoing transaction issues I am writing statements that sets up isolation levels on SQL statements. It appears that I have done something that prevents even seeing specific records in the database. AFAICT I have done commits etc. Is there any way to "undo" whatever the issue is? Is there any way to SEE what the issue is? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com