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

SYMPTOMS

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.

mmc.exe
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.

WORKAROUND

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.

STATUS

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.