Most of the tools in the market will allow you to create a
file from the options you have selected. SQL SP Generator goes one step further
to allow users to select the destination of the script as shown by the
The options are Script To File. In this option you need to
specify the sql file name and path. You can also define the file format for the
SQL File. The options could be Unicode Text or ANSI text.
You are also allowed to copy the stored procedures that are
generated to the clipboard.
Finally, you can just select the default to display the SQL
Script in SQL Server Management Studio itself.
Again, this is following the Microsoft Wizards in SQL Server
Management Studio. Check the Generate Script wizard and you will see the