BUG: Web Assistant: Can Only Save File with .sql Extension (199213)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q199213
BUG #: 46282 (SQLBUG_70)

SYMPTOMS

In the final screen of the Web Assistant (completing the Microsoft SQL Server Web Assistant Wizard), you have the option to "Write Transact-SQL to File". This opens a Save As dialog box. However, unlike in Query Analyzer, you are only given the choice of saving it as one of three .sql types (unicode, ANSI, or OEM). However, the Query Analyzer Save As dialog box lets you also choose other file extensions by using the All Files (*.*) option.

WORKAROUND

There are two workarounds to this problem:
  • In the Save As dialog box surround the name of the file using double quotes, e.g. "test.txt". -OR-

  • After saving the file with a .sql extension, use NT Explorer to change the extension.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB199213
©2002 Microsoft Corporation. All rights reserved.