How to find a String in a Store Procedure?

The following code finds a string thru all store procedures
select from sys.procedures p join 
syscomments c ON
where text like '%TABLENAME%'
To search for a column name in a table use the following:
 Select as tablename,c.* from sys.columns c 
 Join sys.tables t on c.object_id=t.object_id
 where = 'Note'


Related Posts

No Comments Yet.

Leave a reply

You must be logged in to post a comment.