Home Forums SQL Server 2005 Administering change collation on a datase RE: change collation on a datase
noeld
SSC Guru
Points: 96590
More actions
January 14, 2008 at 1:50 pm
#767855
When you do COLLATE it DOES *NOT* change the data that is *already* there. Keneth is right, BCP-OUT->Rebuild->BCP-IN is the way to go!
Cheers,
* Noel