Yes, that does work now. Thanks.

I get duplicates now. See attached.

The results from your SQL have a lot of great details but not exactly what I'm looking for.

All the...

Thanks but non of the SQL works for me again.

I get this error now.

Msg 6850, Level 16, State 1, Line 16

Column name 'TEXT()' contains an invalid XML identifier as required...

yes, that worked this time.

Now, to figure out how to make this into a report of blob columns that have indexes.

I re-copied the SQL from your blog, pasted it into notepad and then copied it out to SMSS.

When I run this code I get the below errors on the 3rd...

yes, I did read your artical at:

http://www.sqlservercentral.com/blogs/sqlrnnr/archive/2010/04/13/blob-report-t_2D00_sql-tuesday-_2300_005_2D00_-reporting.aspx

and picked up the SQL from there but I posted asking for help on why the final SQL would not work. I never...