<div>
This is a great comment for how to actually do it, however, that's not my question.<br />
<br />
Why would someone ever need to do this?<br />
<br />
When I set up a new SQL server, I need to set the collation, and I've always left it as default. Why would I need to change this?
</div>


This is a great comment for how to actually do it, however, that's not my question.

Why would someone ever need to do this?

When I set up a new SQL server, I need to set the collation, and I've always left it as default. Why would I need to change this?

<div>
I should state, I know the reason for changing the collation on a specific db, however, why would I need to change it on the master db?<br />
<br />
I can't think of a scenario that would require this.
</div>


I should state, I know the reason for changing the collation on a specific db, however, why would I need to change it on the master db?

I can't think of a scenario that would require this.

<div>
<div class="content wysiwyg-content">
What reason would you need to change the collation on a MSSQL master database?
</div>
</div>


What reason would you need to change the collation on a MSSQL master database?

MSSQL Master Database Collation

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.