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 operator if it exists
Specify that the script code should replace the operator if it already exists.
Include notifications sent by alerts to the operator
Include in the script any notifications sent by alerts to the operator.
TSQL batch separator
Specify the word used to separate Transact-SQL command batches in the script.
Preview
View the Transact-SQL script that will be created.