I need to change the sql server collation after installation in sql 2016 .
Is it possible to change the database collision on a specific database instead of changing the entire SQL server collision because only one specific project is facing collision issue on sql databse.
Answer by anthony.green ·
Changing the collation is not an easy task once already in place.
The server collation can be done by re-running the setup and rebuilding the system databases passing in the correct collation.
Individual database collations can be done by changing the table collation then the column collation, but this can be time consuming depending on the amount of tables and string columns in each table.
What may be the better option is to create a new database with the correct collation, script out all objects ensuring the collation isn't scripted also, and replay that into the new DB. They copy any data that's needed between the two databases.
This link may come in handy also