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

N_Sri
N_Sri used Ask the Experts™
on


Hi,
 
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 .. :(
Comment
Watch Question

Do more with

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

Author

Commented:
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