Somone smarter than me may know different, but I don't think that is
possible from Enterprise Manager for SQL 2000

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


[quoted text, click to view]

Hi all
I saw that in sql server 2005 express - I can right click a stored procedure
and run it.
Is it possible in sql server 2000?
How please

TIA
Guy

Hi,

We can not execute a procedure by just right clicking in SQL 2000 using
Enterprise manager or Query Analyzer; probably possible by some third party
tools.

Thanks
Hari


[quoted text, click to view]

Not quite the same thing, but close.

In SS2K, Object Explorer in Query Analyzer, you can right-click and choose
"Debug," which will open an execute dialog that will allow you to specify
parameter values and then execute the procedure.

Sincerely,


Anthony Thomas


--

[quoted text, click to view]

I run a SQL2000 Standard DB and installed the SQL2005 tools (express or
standard, either way works) on my workstations and I can use most of the
tools against the remote server, including executing a SP by right clicking.

HTH,
Jim

[quoted text, click to view]