This is how you can change text column collation to something else
ALTER TABLE tableName ALTER COLUMN columnName nvarchar(1000) COLLATE Latin1_General_CI_AS
Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags