FIX: DUMPs May Halt Queries That Have TriggersLast reviewed: May 1, 1997Article ID: Q135869 |
The information in this article applies to:
SYMPTOMSWhen you dump the transaction log or the database while users are running queries which fire triggers that reference the INSERTED and DELETED tables, this may cause the users' queries to be blocked for the duration of the DUMP TRAN or DUMP DATABASE command.
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.
MORE INFORMATIONThe INSERTED and DELETED tables inside a trigger are virtual tables created from their log entries. During a DUMP TRANSACTION or a DUMP DATABASE command, triggers that use these tables may be blocked until the DUMP TRANSACTION or DUMP DATABASE command is completed.
|
Additional query words: sql6 blocking syslogs
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |