Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 7th, 2007, 04:22 PM
Authorized User
Join Date: Jul 2003
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL 2005 Stored Proedure Wizard

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.

Old February 8th, 2007, 02:13 PM
SQLScott's Avatar
Wrox Author
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
reg conn to sql server 2005 from vb.net 2005.. veda SQL Server 2005 2 July 1st, 2008 12:16 AM
Where is the "Class wizard" from 2005 IDE of MFC?? Ramon.Chen Visual C++ 2005 1 August 17th, 2007 09:38 PM
Import Wizard trouble in 2005 Gert SQL Server 2005 2 March 28th, 2006 06:37 AM
Problem w/ SQL Server Database Wizard seanmonahan VB Databases Basics 0 June 25th, 2003 03:24 AM
DTS Export Wizard (SQL to Access 2000) fails ctudose SQL Server 2000 2 June 13th, 2003 05:46 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.