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
Summary – This screen finally displays all the selected
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.