Solved

Change Server Collation in SQL 2008 after installation

Posted on 2011-03-15
9
815 Views
Last Modified: 2012-06-21
Hello experts,

I need to change server collation in SQL 2008 from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS. Is this possible?

Please advise.

Thanks and Regards
0
Comment
Question by:goprasad
9 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 35144263
you need to rebuild  the master database
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 35144295
0
 

Author Comment

by:goprasad
ID: 35144348
After dropping user databases, I need to run the following command, be selecting new query. Is the following fill up the blanks correct?

Setup /QUIET /ACTION=REBUILDMASTER /INSTANCENAME=<my instance name>
/SQLSYSADMINACCOUNTS=sa /[ SAPWD= StrongPassword ]
/SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 35144356
you dont need to drop the user dbs.
seems to be correct
0
 

Author Comment

by:goprasad
ID: 35144418
When I run the query I am getting the msg: Incorrect syntax near '/'
0
 
LVL 77

Expert Comment

by:arnold
ID: 35144568
As referenced in the link posted by aneeshattingal, can you use a per database collation settings as referenced in the Note:?

Note

Instead of changing the default collation of an instance of SQL Server, you can specify a default collation for each new database you create.
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 35145016
Try this as a one line command, remove the line breaks to get rid of the syntax error.

Bye, Olaf.
0
 

Author Comment

by:goprasad
ID: 35186900
I took the easy way out, re-installed the named instance with correct collation.
0
 

Author Closing Comment

by:goprasad
ID: 35186914
I had to re-install the SQL Named instance selecting the correct collation.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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