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)

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,

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

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