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

• Microsoft SQL Server version 7.0

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

Additional query words: name filename ext

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