Post reply

changing the sql collation

  • February 1, 2007 at 2:40 am

    #118650

    On the msdn site it gives the following command as the way to change the default collation on server. I have tried a number of times and it runs the setu routine but the master and server collations remain as they were.

    start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI

    Has anyone else tried this succesfully.

    http://msdn2.microsoft.com/en-us/library/ms179254.aspx

  • February 1, 2007 at 11:36 am

    #687180

    Martin,

    this command not only may change the collation, but it will totally rebuild Master database including login information. I would specify the collations for individual databases.

    Regards,Yelena Varsha

  • February 2, 2007 at 4:27 am

    #687356

    I have recently done this and it worked ok had some problems but was due to the install source

    explained at the end of this thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=269173

    I had to rebuild the server collation because temp db were getting created with server default collation so changing individual db's was not an option. If i remember correctly it also wiped msdb and all the replication had to be setup. backup your msdb before hand.

  • February 5, 2007 at 2:41 am

    #687693

    The server is loated in a different city, when using RDC to connect I was not using a login with high enough priveleges. VNC onto the box let me use a different account and it worked with no problems, I had tried setting the specific data base collation  earlier but on of our applications insisted on the master and temp db being the same as the application db so it had to go.

    Thanks for the comments

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply