Solved

Change Server Collation in SQL 2008 after installation

Posted on 2011-03-15
9
812 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
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.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

785 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