• Thanks for the feedback Kevin - that data type should have been included.

    I replicated the error (by creating a table with a GUID) and then modified the section that limits the types...all worked for me.

    replace:

    select table_name, table_schema, column_name from information_schema.columns where data_type not in ('image','text','timestamp')

    with:

    select table_name, table_schema, column_name from information_schema.columns where data_type not in ('image','text','timestamp','uniqueidentifier')

    I'll update the script on the article. I also like the above comment to limit the field search based on the column size. No use looking in a two character field to see if a 5 character string exists!!! That is the great part about a forum like this -- many people will suggest improvements. Also, to anyone else out there I am aware of the ms_forEachTable procedure but decided to write the script as shown.