BUG: SEM: Saving Scripting File Behaves Differently on Alpha

• Microsoft SQL Server version 7.0

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

Additional query words: machine machines filename filenames

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

Last Reviewed: March 13, 1999