In this part we will look into the install and how the application ties up to SSMS.

But before we look into it, let me be clear on one thing, this is not a Windows desktop application. It is strictly an add-in on SSMS for SQL 2005. The interface for SQL SP Generator is very professional, following the same look and feel of Microsoft’s SQL 2005 SSMS Wizards. It has a welcome splash screen which can be hidden by checking the hide checkbox.

The wizard interface has the following steps:-

Welcome screen – Gives you some information on what the wizard will do.

Choose Options – This screen allows you to define your standards for generating the stored procedures.

Output option – Allows you to select your preferred output for the generated code. The options are Script to File, Script to Clipboard and Script to New Query Window.

Select Table – This interface has a cool look and feel that allows you to select the table(s) for which you would want to generate stored procedures for. It even displays the parent table for the selected table (I will explain this feature in details later).

User Permissions – The developer can even script the user permissions for the stored procedures that will be generated by the Stored Procedure Generator.

Summary – This screen finally displays all the selected options.

In general, the SQL SP Generator developers have used the same format and layout that is used in Microsoft SSMS. If you use the SSMS generate scripts wizard, you will get some idea about it.