Blog Stats
  • Posts - 17
  • Articles - 2
  • Comments - 16
  • Trackbacks - 1

 

<< Sql Server Stored Procedure oddity | Home | REST style urls not working in IIS >>

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 @ Friday, May 26, 2006 12:15 PM

Feedback

# re: Script to search in Stored Proces

Gravatar 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





 

 

 

Copyright © Shailen Sukul