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 following figure.

Figure 4

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 similarities.