How to find all SP using a particular column of a table ?


SELECT * FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Columname%'
Or
SELECT * FROM sys.objects
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Columname%'

No comments:

Post a Comment

Plz Share your comments...