code_junkie

Find Sybase stored procedure in db given a text string that appears in the proc

Nov 12th, 2011
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. select * from SYS.SYSPROCEDURE where proc_defn like '%whatever%'
  2.  
  3. select * from syscomments where texttype = 0 and text like '%whatever%'
  4.  
  5. select object_name(id),* from syscomments
  6. where texttype = 0 and text like '%whatever%'
  7.  
  8. select distinct object_name(id) from syscomments
  9. where texttype = 0 and text like '%whatever%'
Add Comment
Please, Sign In to add comment