FIX: AV in Update Mode When Script Is Run Twice

ID: Q154018


The information in this article applies to:


SYMPTOMS

This problem arises with simple scripts that use trace flag 323 to determine if UPDATE IN PLACE is occurring. When you run such a script twice, an access violation (AV) occurs.


CAUSE

The cause may lie with trace flag 323.


WORKAROUND

To avoid this problem, do not use trace flag 323. Without the trace flag, the script will run successfully.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: sp1


Keywords          : kbbug6.50 kbfix6.50.sp1 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 1, 1999