Article ID: 199279
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q199279
BUG #: 52042 (SQLBUG_70)
SYMPTOMS
While performing database scripting, the file name that you provide for saving the script can be inconsistent between Alpha and Intel X86 versions of SQL Server.
In the Save As dialog box, the default for Save As Type is *.sql. If you type the full name of output file with a .sql extension (for example, "pubs.sql"), the SQL scripts will be saved into a file named Pubs.sql on X86 platforms. However, the file will be named Pubs.sql.sql on Alpha computers.
Note that Notepad.exe on Alpha computers works the same as for X86 platforms.
WORKAROUND
To work around this problem, do either of the following:
- Type the file name without using an extension. It will be saved with a .sql extension by default.
-or-
- Use quotation marks (") around the full file name. This will save the file under the given file name without appending the extension from the Save As Type field. You can also use this method to save the file as different type (for example, "pubs.txt").
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
Additional query words: machine machines filename filenames
Keywords: kbbug kbpending KB199279
