This question already has an answer here:
- How to change SQL Server collation 4 answers
How can i change server collation without changing whole databases, because i have many databases which aren't belong to me, so i want change server collation and my database only.
SQL Server version: 2016 SQL Server Collation: Arabic_CI_AI
in the server i have many databases, some of these databases i work on them and others are not belong to me and should not be touched. I want to change the collation: Arabic_100_CI_AI
When i use this script:
sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"Arabic_CI_AI"
it change the server collation along with all databases in the server, but i don't want this i need to do change only the collation of the server only.
Is that possible?