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

Article translations Article translations
Article ID: 246564 - View products that this article applies to.
This article was previously published under Q246564
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 55907 (SQLBUG_70)
Expand all | Collapse all

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.

Properties

Article ID: 246564 - Last Review: October 22, 2013 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB246564

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com