Microsoft KB Archive/246564

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

Article ID: 246564

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q246564



BUG #: 55907 (SQLBUG_70)



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.

Keywords: kbbug kbfix KB246564

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.