Export (0) Print
Expand All
Expand Minimize

Generate SQL Script

SQL Server 2000

Use this dialog box to view or specify the following options.

Options

File name

Specify the file name for the SQL script. Click the browse (...) button to select a file name to use for saving the SQL script

MS-DOS text (OEM)

Save the Transact-SQL script in the format of the current Microsoft® Windows® system code page. Select this option if you will use the script in a batch operation and execute it from the command prompt.

Windows text (ANSI)

Save the Transact-SQL script in ANSI format. Select this option if the script will be used in SQL Query Analyzer or another Windows application.

International text (Unicode)

Save the Transact-SQL script in Unicode format. Select this option if the script uses special international characters that are supported only in the Unicode font. This format requires two times the disk space of either the current Windows code page or ANSI.

Replace job if it exists

Specify that the script code should replace the job if it already exists.

TSQL batch separator

Specify the word used to separate Transact-SQL command batches in the script. This is useful if Transact-SQL job steps already contain the GO command separator.

Preview

View the Transact-SQL script that will be created.

See Also

Scripting Jobs Using Transact-SQL

Show:
© 2014 Microsoft