view the logic behind procedure in SQL Server

Posted by Bandi under Sql Server category on | Points: 40 | Views : 161
Method 1:
SELECT OBJECT_NAME(o.object_id), c.text FROM sys.syscomments c
join sys.objects o on o.object_id =
where o.type= 'P' and name = 'SP Name '

Method 2:
sp_helptext 'SP Name '

Comments or Responses

Login to post response