thank you, there are so many ways to get this info starting with SSMS, but this one i like too.

yes you must run the first query to create the function

I rebuild my indexes every month after big loads I guess each one

must have or not have reasons to do...

this is really good what you posted

my original idea was to show just the tree of dependencies

no details about columns just the Map so that you could see

who called who...

Dynamic sql handling could be done but it will take some doing

maybe writing an extended procedure or simple writing a class inj c# or C++ and

call it from the...

thanks all of you who have commeted it on the article

my hope is it could help some one doing something.

it helped me a similar script at work from which i...

yeah i know i have scripts which refresh all objects

but like you said it does not work all the time

is a time issue becuase days later it works

so :O)

i had not seen this problem, i ran the script againts 4 or 5 databases including my big ones at work

and all was fine for a few 2 o3 views...

yes i have seen it yeah hey is not perfect

i could handle dynamic maybe in the future, becuase i use little dynamic, i use a different technique

to avoid dynamic then..

As it happens i notice thast some objects did not show, i did a deep study and came so what was happenning

for some reason Microsoft was not updating some objects...