Microsoft KB Archive/199213

= BUG: Web Assistant: Can Only Save File with .sql Extension =

Article ID: 199213

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Additional query words: name filename ext

Keywords: kbbug kbpending KB199213

-

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

© Microsoft Corporation. All rights reserved.