Get error on changing Collation property of Master database of SQL Server

Posted on 2009-02-17
Medium Priority
Last Modified: 2012-05-06
When I change Collation property of Master database in SQL Server 2008, I am getting an error (Please check attached screen-shot for more details).

Does anyone know how can i get rid of this issue?

Question by:GMurad
LVL 43

Assisted Solution

pcelba earned 600 total points
ID: 23658162
Case Sensitive collations are nightmares sometimes...

Create a backup of all your non-system databases, reinstall the SQL Server with proper Collation and restore your backups.
LVL 57

Accepted Solution

Raja Jegan R earned 900 total points
ID: 23658167
To change the collation of master database, you have to use rebuildm utility. You cant do it from SSMS.

But if you need to change the collation of either master or temp database, My kind advice would be to reinstall SQL Server with appropriate collation.

Kindly backup essential things before reinstallation to be on the safer side.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question