Hello Everyone and thanks for your help in advance. I am new to SQL Server 2005 and am trying to understand the Stored Procedure Wizard. In SQL 2000, it seems that the wizard does a lot more of the actual generation of the sproc. Also, I haven't figured out how to change the wizard to create an update, insert, or delete sproc. I'm hoping that I'm simply not understanding how to effectively use it, but it really seems like the wizard has taken a step back. Can someone give me some insight or articles on how to effectively use this? Any help would be greatly appreciated.

Hi Hugh,

I think Microsoft went a different direction with these wizards. Yes, Microsoft took them away but they replaced them with something even more rebust (depending on how you look at it).

You have several options. Option 1, which you probably have already seen, is to right mouse click on the Stored Procedures tab and select "New Stored Procedure...". This will give you the base template from which to create your stored procedure.

In place of the wizard, Microsoft gave you something really cool, in my opinion. From the View menu, select "Template Explorer". If you have not already seen this, this explorer provides with you countless templates to choose from, offering much more than SQL 2000 did, however they are not "wizard driven".

Basically, they replaced with wizards with templates for "every-day" tasks.

So, did they take a step back? Well, it depends on how you look at it...



Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html