Knowledge Base

FIX: AV in Update Mode When Script Is Run Twice

Article ID: 154018

Article Last Modified on 10/3/2003


APPLIES TO


This article was previously published under Q154018

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: kbbug kbfix KB154018