<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Blesson John
»
Changing Server Collation on SQL Server 2008
19 posts, Page 2 of 2
««
1
2
Changing Server Collation on SQL Server 2008
Rate Topic
Display Mode
Topic Options
Author
Message
blessonblessons
blessonblessons
Posted Friday, March 09, 2012 6:07 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55,
Visits: 391
Will help you change the collation.It is good that you have backed up the database and scripted out all the user defined jobs associated with the instance.Also script out the user logins.
If you have customized any other setting at the server level then make note of them.Run sp_configure to get all the server level setting.
The command to change the server level collation is to:-
Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName
/SQLSYSADMINACCOUNTS=accounts /[ SAPWD= StrongPassword ]
/SQLCOLLATION=CollationName
This will basically rebuild the system databases with the new desired collation.This method is faster than reinstalling SQL Server.
refer the below link
http://msdn.microsoft.com/en-us/library/ms179254.aspx
Post #1264309
blessonblessons
blessonblessons
Posted Friday, March 09, 2012 6:19 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55,
Visits: 391
In case you are wondering where the setup file is you will find it on the install CD or depending on whether it is a x86 (32-bit) install or x64 (64-bit) install the file location will vary.
eg:- for x64 (C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2)
Post #1264322
philip.kraft
philip.kraft
Posted Friday, March 09, 2012 6:23 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, March 14, 2013 10:29 AM
Points: 5,
Visits: 54
Perfect! Thanks. I actually just managed to make a success of it on my local machine with the script you gave me! Server Collation was changed from Latin1_General_CI_AS to Latin1_General_CI_AS_KS_WS with no issues!
I will try it on the sandbox server and let you know.
Thanks so much.
Phil.
Post #1264324
philip.kraft
philip.kraft
Posted Friday, March 09, 2012 6:35 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, March 14, 2013 10:29 AM
Points: 5,
Visits: 54
No luck on the server like I had on my local instance
Y:\>setup /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=REBUILDDATABASE /INSTANCENAME
=MSSQLSERVER /SQLSYSADMINACCOUNTS=MyDomain\MyUsername /SAPWD=thesapassword /SQLCOL
LATION=SQL_General_CP1_CI_AS
Microsoft (R) SQL Server 2008 R2 Setup 10.50.1600.01
Copyright (c) Microsoft Corporation. All rights reserved.
The following error occurred:
The state of your SQL Server installation was not changed after the setup execut
ion. Please review the summary.txt logs for further details.
Error result: -2068643838
Result facility code: 1203
Result error code: 2
Post #1264334
blessonblessons
blessonblessons
Posted Friday, March 09, 2012 7:38 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55,
Visits: 391
Can you please attach the log file for review?
Thanks
Blesson
Post #1264398
blessonblessons
blessonblessons
Posted Friday, March 09, 2012 8:13 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55,
Visits: 391
The log file will be placed in the folder:-
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
Post #1264423
philip.kraft
philip.kraft
Posted Monday, March 12, 2012 1:00 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, March 14, 2013 10:29 AM
Points: 5,
Visits: 54
Thank you again John for all the help! Do you perhaps have an email address I can forward the logs to?
Post #1264988
blessonblessons
blessonblessons
Posted Monday, March 12, 2012 1:12 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55,
Visits: 391
No worries Phil,my email address is blessonblessons@yahoo.com.
Post #1264992
afterx
afterx
Posted Sunday, March 18, 2012 7:56 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, March 18, 2012 7:54 PM
Points: 3,
Visits: 171
philip.kraft you can run this on sql 2005, 2008, and 2008 R2. You just have to make sure the server collation is different from the one you want to go to. More information can be found
Here
-JM
Post #1268783
« Prev Topic
|
Next Topic »
19 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
