Microsoft KB Archive/246564

From BetaArchive Wiki
Knowledge Base

FIX: SQL Enterprise Manager AVs on Copy of Large SQL Script from Preview

Article ID: 246564

Article Last Modified on 3/14/2006


  • Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q246564

BUG #: 55907 (SQLBUG_70)


When you copy a large SQL script (around 650 KB or larger) of a database that was scripted from the Preview window in SQL Server Enterprise Manager (SEM) and you then click Close, SEM may stop responding due to an Access Violation (AV) and a Dr. Watson error message similar to the following displays:

An application error has occurred
and an application error log is being generated.

Exception: access violation (0xc0000005), Address: 0x77f64d8a.

If that does not happen, the Cancel button on the parent window becomes disabled, which makes getting out of this window impossible, and if you now click the Preview and Copy buttons again, SEM will stop responding with the Access Violation and preceding Dr. Watson message.


To work around this problem, do not use the Preview button on the Generate SQL Scripts dialog box when you are scripting large and complex databases. Instead, click OK and save the script to a file. Then use any text editor, like Notepad, to modify the file.


Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

Keywords: kbbug kbfix KB246564