Finding all Views which use Table name and Column name of the same table

N_Sri used Ask the Experts™

Think that there is table ( Employee ) with Fields Name(Varchar), Active(Smallint),LastName(Varchar).
So this table is being used in many Views . Now I wanted to find all Views  which use table Employee and use Active(Smallint) in the Stored Procedure code...
Please help me to have such query.... I found some query by useing Text search... but it was not getting correct data.
litte urgent .. :(
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You asked the same questions and did you try those answers? Did you have any issues?


yeah, the result was not giving the exact data ...

We thought go mannually... :(

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial