posts - 18, comments - 23, trackbacks - 1

My Links

News

This blog has moved to http://shailen.sukul.org

Article Categories

Archives

Post Categories

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%'

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

Feedback

Gravatar

# re: Script to search in Stored Proces

try this:

select *
from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE='PROCEDURE'
and ROUTINE_DEFINITION LIKE '%SearchString%'
12/7/2006 10:50 PM | Torben
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

Powered by: