August 27, 2021 at 11:38 am
No easy way, if you want to change everything you need to script everything out and do a find replace and regenerate the database then reinsert the data.
The alternative is to add the “COLLATE DATABASE_DEFAULT” option to everywhere to make sql pick a default or specify a particular collation on each reference to a table, join, view etc etc in each query you run.
August 27, 2021 at 3:18 pm
Agree, there's no super-easy, "automatic" way to do that. However, you can generate a script(s) that will change each column as needed, so it's not like you have to do it all by hand.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply