question

Mehdi593 avatar image
Mehdi593 asked

Change server collation SQL SERVER 2014, 2016

How to change server collation without reinstall ? I run the command : "C:\Program Files\Microsoft SQL Server\MSSQL12.FIRST\MSSQL\Binn\sqlservr.exe" -m -T4022 -T3659 -s"instance name" -q"french" And raise error : An invalid startup option 'q' was supplied.
collation
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Firstly, -q is an undocumented and unsupported option. If you break something, MS support will not help. What it does is to rebuild the system databases using the collation given. It was removed in SQL2016, and the correct way to do this is to rerun the install with the /ACTION=REBUILDDATABASE option. It will achieve the same thing. https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?view=sql-server-2017 Usual caveats - backup EVERYTHING first! Obviously this will not change the collation of any columns in user databases that you created under the current collation - what exactly are you hoping to achieve from all this.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.