Home Forums SQL Server 2008 T-SQL (SS2K8) Update Help.. RE: Update Help..
umarrizwan
Old Hand
Points: 354
More actions
March 29, 2013 at 4:21 pm
#1602188
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'