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 : 2052 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...