RSS feed

How can i see the code (SQL Create Statement) for a stored procedure in SQL server

Published by: Rinku (9/7/2008 11:06:27 PM)

SEP 7 2008

I am trying to view the T-SQL statements that make up a pre-defined stored procedure in SQL server. But when I select a stored procedure and right click on it, in SQL Server Management Studio, I have no option to view the code. I do have the choice to modify the stored procedure which opens up with an ALTER PROCEDURE statement, but i am interested in seeing the CREATE PROCEDURE statement. Please help,


what is the command to list all tables in a database in SQL Server >>

<< Why my MS SQL Server 2005 DSN Connection is not Working



You can use HTML tags here.
*Code: Please enter the sum of 5+2