• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • Last Modified:

Change Server Collation in SQL 2008 after installation

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
goprasad
Asked:
goprasad
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
you need to rebuild  the master database
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
goprasadAuthor Commented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Aneesh RetnakaranDatabase AdministratorCommented:
you dont need to drop the user dbs.
seems to be correct
0
 
goprasadAuthor Commented:
When I run the query I am getting the msg: Incorrect syntax near '/'
0
 
arnoldCommented:
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
 
Olaf DoschkeSoftware DeveloperCommented:
Try this as a one line command, remove the line breaks to get rid of the syntax error.

Bye, Olaf.
0
 
goprasadAuthor Commented:
I took the easy way out, re-installed the named instance with correct collation.
0
 
goprasadAuthor Commented:
I had to re-install the SQL Named instance selecting the correct collation.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now