Deep Dive into Changing Database Collation

• ruudvandebeeten

  Grasshopper

  Points: 16

  More actions

  April 6, 2016 at 2:54 am

  #1870074

  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.