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

Posted by Sahoo under Sql Server on 6/18/2013 | Points: 10 | Views : 989 | Status : [Member] | Replies : 1
Hi
How to find all SP using a particular column of a table ?
Let say I have a table USER with column Email. I want to find out all SP using Email field of USER table .

Thanks in advance




Responses

Posted by: Saranya Boopathi on: 6/18/2013 [Member] Starter | Points: 25

Up
0
Down
Hi Sahoo ,

I hope this query helps you.Run it in Selected DB

SELECT distinct so.name

FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%Email%' and sc.TEXT LIKE '%User%'


If you statisfy with this answer..Mark this post as Answer.

Saranya Boopathi

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response