I am not that new to Sql Server but I began using Sql Server Ent 2008 just a
month or two ago. I recall that in 2005 Express there was that option. You
generate a query or you just use an older query or Stored Procedure and you
open that GUI and what was the most important you had an option to assign
all parameters and execute the query with parameters which would result in
your having rows of the output.

I cannot find it in Sql Server 2008 Enterprise. Has it been removed or I
simply forgot where it is?

Thanks.

I think that option still exists, but I can't remember off the top of my
head how to get to it.

I do know that in Management Studio, you can navigate to your sproc and then
do Script to Execute in new window. That will
allow you to setup your variables and execute the sproc. If you need to
debug the sproc though, then you'll need the option
you're looking for. I'm pretty sure it's there, just don't remember off
hand where.

"AlexB" <alexblaivas (AT) comcast (DOT) net> wrote

Hi AlexB,

I am not sure if this is what exactly you want to know but If you
right-click on a stored procedure in SQL Server 2008 Management Studio and
select the option "Execute Stored Procedure" you are allowed to set the
parameters (if any) for the stored procedure and the query is then
constructed automatically.

If the above does not answer to your question, can you provide some more
details?

Cheers.

--

Artemakis Artemiou, SQL Server MVP
http://aartemiou.blogspot.com

This post is provided "as-is" and confers no rights.



"AlexB" <alexblaivas (AT) comcast (DOT) net> wrote

Hi Artemakis,

Right clicking and selecting 'Execute' works when I am in a vs2005 database
but the 'Execute' doesn't show up on the menu if I am in a SQL Server Express
database. Do you have any insight into this behavior? Am I missing
something?

Any help would be appreciated.

Thanks.

"Artemakis Artemiou" wrote:

Do you mean the Specify Values for Template Parameters option on the query
menu? Also available using Ctrl+Shift+M.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"AlexB" <alexblaivas (AT) comcast (DOT) net> wrote

Hi Rick,
No. I am talking about the "Execute Stored Procedure" item on the context
menu that shows up if you right click on a stored procedure. The context
menu item is there if I right click on a SP in a 2005 database but not there
if I right click on a SP in a SQLExpress 2005 database.

"Rick Byham, (MSFT)" wrote:

KellyP (KellyP (AT) discussions (DOT) microsoft.com) writes:
Exactly which version of SQL Server Management Studio are you using?
I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express instances,
and the item is there on the context menu.

The only thing I can think of is that you don't have EXECUTE permission
on the procedure and SSMS is smart enough to check for this.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx