• Hi,

    Love the script.

    I had a small problem when I tried running it due to the collation being wrong. I was getting the error

    Cannot resolve collation conflict for column 1 in SELECT statement.

    To fix this I changed the following at the end of the script

    -- Script the end of the statement

    PRINT ' '') COLLATE Latin1_General_CI_AS'''

    PRINT ' FROM ' + @table_name

    This then worked a treat.

    Thanks again