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:
• 
• 
• 

Posted On Friday, May 26, 2006 12:15 PM | Feedback (1) | Filed Under [ Database ]