SELECT obj.Name SPName, sc.TEXT SPText
FROM sys.syscomments sc
INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID
WHERE sc.TEXT LIKE '%' + 'Name Your Column Here' + '%'
AND TYPE = 'P'
Tuesday, July 17, 2012
Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment