Megistal (8/2/2013)
This is nice, helpful and I hope to see more from you but the script take for granted that the searched object is unique amongst all other objects name even part of it.For instance looking for Table1 when Table123 is solely used inside an object will shows that object as if Table1 used it instead which is not the case.
Thanks for pointing that out. I hadn't considered this scenario, maybe because I haven't encountered a situation with objects named that way. I guess I could code for it by checking the charindex of, say Table1, and comparing it to the charindex of Table123. If they have the same value, I know I have Table123 and not table 1.
Hakim Ali
www.sqlzen.com