Microsoft KB Archive/154018

From BetaArchive Wiki
Knowledge Base


FIX: AV in Update Mode When Script Is Run Twice

Article ID: 154018

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



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