Can we change collation of the db after it has filled with some data..?
asked Apr 13 '11 at 08:27 AM in Default
You can change the collation of a database at any time, but only new objects will have the new collation. To change existing objects you would need to script out each column of each object that has the collation (i.e. character fields) for example:
answered Apr 13 '11 at 08:54 AM
Kev Riley ♦♦