Knowledge Base

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

Article ID: 199213

Article Last Modified on 10/16/2002

APPLIES TO

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.