How to chnage Collation for EVERYTHING in a database

Will Gilbert

Member
Joined
Dec 1, 2020
Messages
6
Programming Experience
5-10
Just restored a database from another site and running into all sorts of problems to do with Collation
Is there any 'easy' way to just completely change Everything in a database to a specific collation
e.g. Tables, Columns, Indexes, Constraints,. in other words everything
Something like: Change Database MyDatabase to Collation Latin1_General_CI_AS

(I cannot find ant 'simple way to do this)
 
I don't understand why this is C# question. Sounds more like a SQL question.
 
I just searched the web for "sql server change collection for database" and this was the first result. Am I missing something or did you not bother searching for yourself before posting? If you did find that page and did what it instructs then what's the actual problem? If we don't know what you did and what happened then we can't know what you did wrong.
 
Back
Top Bottom