At my current job we depend a lot on stored procedures for our web applications and sometimes it gets really boring when we have to write and re-write stored procedures for different databases and tables as demands increase. This pain has me looking for an easier and faster way to generate standard stored procedures that would meet our database design specifications. A few years back I stumbled on some source code developed by e Tek Global that would create stored procedures, but there were some short comings with the brilliant tool because I had to know and pass my parameters to make the procedures usable since it did not have a front end GUI. With my hunger then to still make my job easier I went Googling and bought a tool with a GUI but it still it had its own issues.

A few days ago I received an email from e Tek Global regarding a new SQL 2005 add-in tool to do a similar job as the one they had developed previously. With the descriptions it looked attractive but I was not sure if it would be good enough to replace what I had. I decided to give it a try with the evaluation copy. I was amazed by what the tool could do despite some features not being function on the evaluation copy. I was still able to generate powerful, well designed stored procedures. So here I am giving you a sneak peek into SQL SP Generator.