August 16, 2010 at 7:20 am
I know Redgate do a SQL dependancy checker but it doesn't seem to look at views. An appication we have seems to rely heavily on nested views, lots of them. I need a quick way of assesing which ones they are, any ideas ?
August 16, 2010 at 7:30 am
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
August 16, 2010 at 7:32 am
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.
August 16, 2010 at 7:44 am
give it to developer who designed the application..
----------
Ashish
August 16, 2010 at 7:48 am
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
August 16, 2010 at 8:28 am
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
http://www.mssqltips.com/tip.asp?tip=1250
----------
Ashish
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply