Executing a Stored procedure in Enterprise manager 3

[btween]

I'm new to stored procedures, and I can't figure out how to run a stored procedure to get a result set from Enterprise manager.

I have the following SP:

CREATE PROC au_info @lastname varchar(40), @firstname varchar(20) 
AS 
SELECT lname, fname, ts
FROM tester
WHERE fname = @firstname 
AND lname = @lastname
GO

MSDN sais to:

1 In Data View, expand the Stored Procedures folder.


2 Right-click the name of the stored procedure that you want to run.


3 Choose Execute from the shortcut menu. The Output window shows the status of the stored procedure.


The problem is that I don't have an execute command there.

I am running Enterprise Manager for SQL server 2000

thanks fo ryour help

 

[ecobb]

You can open up Query Analyzer and type

EXECUTE au_info 
@lastname = [red]whatever[/red], 
@firstname = [red]whatever[/red]

Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[SQLSister]

YOu can' execute sps in Enterprise Manager, you use Query Analyzer for that. YOu can use the object browser to execute and Sp. Find the sp you want inthe list, right click on it and selct open, I twill open up a window which will tell you the tparameters and let you set the values you want, then once you have done that click the Execute button.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief