"Shimon Sim" <shimonsim048@community.nospam> wrote in message
news:%230ABcjy4FHA.1184@TK2MSFTNGP12.phx.gbl...
>I just started looking in management studio for SQL Server 2005 and can't
>find SP wizard. I Used it a lot even though it was a little pain to remove
>all the numbers that it attached to parameters.
> Is there something else I can use to automatically create simple SPs?
> Thank you,
> Shimon.
>

"Gail Erickson [MS]" <ga***@online.microsoft.com> wrote in message
news:u$vNgmz4FHA.2676@TK2MSFTNGP15.phx.gbl...
> There is a New Stored Procedure task you can use.  Here are the
> instructions.
>  1.. In Object Explorer, connect to an instance of SQL Server 2005
> Database Engine and then expand that instance.
>  2.. Expand Databases, expand the database in which the stored procedure
> belongs, and then expand Programmability.
>
>  3.. Right-click Stored Procedures, and then click New Stored Procedure.
>
>  4.. On the Query menu, click Specify Values for Template Parameters.
>
>  5.. In the Specify Values for Template Parameters dialog box, the Value
> column contains suggested values for the parameters. Accept the values or
> replace them with new values, and then click OK.
>
>  6.. In the query editor, replace the SELECT statement with the statements
> for your procedure.
>
>  7.. To test the syntax, on the Query menu, click Parse.
>
>  8.. To create the stored procedure, on the Query menu, click Execute.
>
>  9.. To save the script, on the File menu, click Save. Accept the file
> name or replace it with a new name, and then click Save.
>
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Shimon Sim" <shimonsim048@community.nospam> wrote in message
> news:%230ABcjy4FHA.1184@TK2MSFTNGP12.phx.gbl...
>>I just started looking in management studio for SQL Server 2005 and can't
>>find SP wizard. I Used it a lot even though it was a little pain to remove
>>all the numbers that it attached to parameters.
>> Is there something else I can use to automatically create simple SPs?
>> Thank you,
>> Shimon.
>>
>
>

> Thank you.
> But it not what I was looking for.
> I am looking for feature that helps me with creating correct parameters
and
> creating basic query as the SP wizard used to do.
> The feature you described existed in QA,didn't it?
> Addition of query designer is major improvements even though it existed in
> VS.NET for a while.
> I guess I will miss the old SP wizard.

"Martijn Tonies" <m.tonies@upscene-removethis.nospam.com> wrote in message
news:ugZxg4R5FHA.2916@TK2MSFTNGP11.phx.gbl...
> Well, you could try our Database Workbench tool ( www.upscene.com )
> it has a "Create SUID Procedures" if you right click on a table and that
> seems to do pretty much the same.
>
>> Thank you.
>> But it not what I was looking for.
>> I am looking for feature that helps me with creating correct parameters
> and
>> creating basic query as the SP wizard used to do.
>> The feature you described existed in QA,didn't it?
>> Addition of query designer is major improvements even though it existed
>> in
>> VS.NET for a while.
>> I guess I will miss the old SP wizard.
>
>
> --
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>

"Martijn Tonies" <m.tonies@upscene-removethis.nospam.com> wrote in message
news:Opi2fwW5FHA.2484@TK2MSFTNGP09.phx.gbl...
> Hello,
>
>> Yes, That is very much what I need ... but why the pens don't refresh??
>> You program uses few pens (separate views) and they just don't refresh on
> my
>> machine.
>> Do you know about it?
>
> Can you explain this a bit better?
>
> Please use our supports newsgroups or support @ upscene.com so we
> will be able to answer timely.
>
>
> --
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>

"Sophie Guo [MSFT]" <v-s***@online.microsoft.com> wrote in message
news:EdamETc5FHA.832@TK2MSFTNGXA02.phx.gbl...
> Hello,
>
> In SQL server 2005 management studio, you can use the "Specify Values for
> Template Parameters" dialog box to specify values and data type  for
> parameters in stored procedures or functions. You can test it by
> performing
> the following steps:
>
>  1. In Object Explorer, connect to an instance of SQL Server 2005 Database
> Engine and then expand that instance.
>
>  2. Expand Databases, expand the database in which the stored procedure
> belongs, and then expand Programmability.
>
>  3. Right-click Stored Procedures, and then click New Stored Procedure.
>
>  4.. On the Query menu, click Specify Values for Template Parameters.
>
> You can specify the Parameter, Type, Value for the Stored Procedure in the
> "Specify Values for Template Parameters" dialog box. For more information,
> refer to the "Specify Values for Template Parameters" topic in SQL server
> 2005 books online.
>
> I hope the information is helpful.
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>
>