How to view the stored procedure code in SQL Server Management Studio

sql-server tsql ssms
DG3 picture DG3 · Jan 4, 2012 · Viewed 234.5k times · Source

I am new to SQL Server. I am logged into my database through SQL Server Management Studio.

I have a list of stored procedures. How do I view the stored procedure code?

Right clicking on the stored procedure does not have any option like view contents of stored procedure.

Thanks.

Answer

Kniganapolke picture Kniganapolke · Jun 12, 2013

I guess this is a better way to view a stored procedure's code:

sp_helptext <name of your sp>

Related questions

What is the use of GO in SQL Server Management Studio & Transact SQL?

SQL Server Management Studio always inserts a GO command when I create a query using the right click "Script As" menu. Why? What does GO actually do?

Read More
Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Read More
What is the T-SQL syntax to connect to another SQL Server?

If I need to copy a stored procedure (SP) from one SQL Server to another I right click on the SP in SSMS and select Script Stored Procedure as > CREATE to > New Query Editor Window. I then change …

Read More