Showing Dependancies for Views

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

configure profiler with appropriate filter and then run it in background while doing your activity on your application.

you will get the view names in profiler.

----------
Ashish

Paul Farnell SSC Veteran Points: 208 More actions · Answer 2

I have alreasy done that but it doesn't really lend itself tom easily identifying the ones with most nests. There is hundreds of views.

crazy4sql SSCoach Points: 19590 More actions · Answer 3

give it to developer who designed the application..

----------
Ashish

Paul Farnell SSC Veteran Points: 208 More actions · Answer 4

Ashish, thanks for your help but it misses what I want to do.

I want to find and document the poorly written views and then tell the developers to fix them

crazy4sql SSCoach Points: 19590 More actions · Answer 5

Actually there is nothing predefined steps which you need to follow in such excersie(so far I am aware) but you can very well use tools like dbdesc.

For more information on this...please have a look of

----------
Ashish