June 22, 2007 at 11:09 pm
Hi All,
How do I view an existing sproc's code in Management Studio? In SQL2000 Enterprise Manager all I did was right click on the sproc name and select Properties, and the code was viewable and editable. In SQL2005 Management Studio, when I right click on the sproc name, selecting Properties does not reveal the code. Other Management Studio menu entries do not either, except for the modify entry, which scripts an ALTER PROCEDURE statement. This seems a bit much for simply viewing the existing code.
Sam
June 23, 2007 at 1:03 am
right click (as you said) then "script stored procedure as"; there is not a "view code" option, if this is what you're looking for.
June 23, 2007 at 10:58 pm
Thanks for the reply Michael.
June 25, 2007 at 10:03 am
I think Enterprise Manager ran ALTER PROCEDURE in the background when you modified a procedure. SSMS just makes it more obvious.
Greg
Greg
June 28, 2007 at 9:05 pm
You're probably right Greg. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply