Why I had to change the collation settings on the dataase is, I recently did a migration frmo 2000---2005 and I just detached the 2000 database and attached it in 2005 server.
So this database collation didn't get updated. It has the same collation as it has on the old 2000 server.
So i tried even restoring the 2000 database on the 2005 server adn still the collation settings didn't get updated.
So will it happen in any migration or what is the best way to make sure it wont happen or how will those collation get updated?