Hey Jeff,

Thanks for your message --- oops, i am using 2005 and didn't realise it was a 2000 forum...my mistake.

Well, the code works amazing... on 2.5 million tables it returns...

Hi All - for those with a similar problem...

i found an awesome solution that i worked through to learn how to use at this link...

http://www.sqlmag.com/Articles/Print.cfm?ArticleID=93462

This is what i came up...