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

ID: Q246564

The information in this article applies to:

Microsoft SQL Server version 7.0

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 version 7.0.

Additional query words:

Keywords : kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug