Generate SQL Script
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.