Dec 31, 2013

Sql query to get script or text of any stored procedures without modifying in sql server


Sql query to get script or text of any stored procedures in sql server

We can get the script or text of stored procedure without modifying the procedure by using the system stored procedure sp_helptext. Synatx:

EXECUTE sp_helptext <ProcedureName>

For example:

EXECUTE sp_helptext 'usp_getdata'

Other sql script:

SELECT m.definition 
FROM sys.sql_modules m INNER JOIN Sys.procedures p
ON m.object_id = p.object_id AND p.name = 'AppProc'

No comments:

Post a Comment