Programming Tips: How to Find Column reference in all Procedures in Sql Server

Thursday 12 February 2015

How to Find Column reference in all Procedures in Sql Server



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 '%' + 'CreatedBy' + '%'

AND TYPE = 'P'

Related Searches : Find the column reference in stored procedure Sql server.

Kindly Bookmark and Share it:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)