Shailen Sukul

Script to search in Stored Proces

Script to search in stored procs

select  upper(SysObjects.Name),SysComments.Text
from  SysObjects, SysComments  
where  SysObjects.type='P'
and (SysObjects.ID = SysComments.ID)
and SysComments.Text like '%SearchString%'

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/KjF

Print | posted on Friday, May 26, 2006 12:15 PM | Filed Under [ Database ]