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?

DFPITC

11/26/2017

ASKER

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.

SOLUTION

Pawan Kumar

11/26/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst