Change default collation when provisioning a SQL Server VM in the Azure portal

If you are going to utilize the images from Azure marketplace for building your SQL Server instances, I'm not aware of any options to change the server collation. Since the image has SQL Server installed already your only option will probably be to just follow the process to change the default server collation after the VM is provisioned. Which requires rebuilding the system databases. You could add this into your build so it executes the needed commands, but you would have to have the installation media available for that version of SQL Server.

Tags:

Sql Server

Collation

Azure Vm

Related

Can't update "CO2" to "CO₂" in table row How do I enforce a write-once then read only database table in SQL? LocalDB v14 creates wrong path for mdf files what would be the right permission to allow everything else but overwriting or creating a database? Homebrew installed PostgreSQL could not connect, database files are incompatible with server How do I format the output from OBJECT_DEFINITION so that it looks the same as sp_helptext? SQL Profiler for Mac OS Using source columns in OUTPUT INTO clause of an INSERT statement (SQL Server) sys.objects column [Type] weird value 'ST' Extract filename without extension from the absolute location Get rows with most recent date for each different item Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

Recent Posts