Deep Dive into Changing Database Collation

  • ruudvandebeeten

    Grasshopper

    Points: 16

    alex.valen (4/1/2016)


    Hi all,

    Just when I need it, somebody posts a nice script! It's a great start, however, still found some bugs / copy-paste-errors:

    • AND ( CHARINDEX(quotename(TBLZ.ColumnName) , quotename(IDXZ.index_columns_key) ) > 0

      OR CHARINDEX(quotename(TBLZ.ColumnName) , quotename(IDXZ.[highlight="#ffff11"]index_columns_key[/highlight]) ) > 0 )

      should be

      AND ( CHARINDEX(quotename(TBLZ.ColumnName) , quotename(IDXZ.index_columns_key) ) > 0

      OR CHARINDEX(quotename(TBLZ.ColumnName) , quotename(IDXZ.[highlight="#ffff11"]index_columns_include[/highlight]) ) > 0 )

      times 6...

    • QUOTENAME returns NULL if input is greater than 128 characters. In my case, at least included_columns is regularly greater than that
    • compression is totally ignored
    • Cheers!

    We also found errors when Change Tracking is enabled and when full text indexes are defined.

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply