CODEWITHSUNDEEP
sqlstored-proceduressql-server-2012view
user2363952
user2363952

Reputation: 1

Which stored procedure using which view?

Description: My project have lots of stored procedure and also lots of views. I would like to know which stored procedure is using which view. Its quite hard, when i have lots of stored procedure.

I know there are some system table which I can use, but the system tables would not have information for the dynamic queries in my stored procedure.

Please let me know, how can i make it. Is there some tool, or stored procedure for the same. I want to see the relationship between my 'stored procedure' and 'views I used in my stored procedure'.

Thanks in advance

Upvotes: 0

Views: 33

Answers (1)

Henrik Staun Poulsen
Henrik Staun Poulsen

Reputation: 13874

I normally use SQL Search from www.RedGate.com, when I want to search for dependencies, and other relations (such as copy-paste code)

Dynamic SQL is a problem because of its late binding.

HIH,

Henrik Staun Poulsen

Upvotes: 1

Related Questions