Post reply

Changing the Server Collation

  • January 16, 2012 at 11:13 am

    #391323

    Hi all,

    I'm setting SQL Server 2005 Database and I need to define the collation "SQL_Latin1_General_CP1_CS_AS" but when I Click on "Collation designator and sort order" for selecting just appear "Latin1_General" no more options related with SQL_Latin1_General.

    Why does not appear this collation I need and what can I do for select it in this installation process instead of Installation finished and running.

    I wonder if this collation option would appear when apply the SQL SP3 or I must to do it after installation by using:

    setup.exe /qb INSTANCENAME=[instance] REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[password] SQLCOLLATION=[new collation]

    I would appreciate any comments,

    Regards,

  • January 16, 2012 at 2:19 pm

    #1434286

    Let's see if I understand correctly:

    1) You are creating a new database or

    2) modifying an existing one

    and you don't see the collation you would like to set in the new database/database properties window

    3) You think that applying SP3 will fix the issue

    4) You think rebuilding the master database will fix the issue

    So, given that the above are correct intepretation of you question, here's my two cents:

    1) You can choose any collation you like when creating a new database. Is this here that you don't find the collation you want? In my setup I see all the possible collations. It would be a very strange issue.

    2) You have to do it manually with alter database:

    ALTER DATABASE test80 COLLATE SQL_Latin1_General_CP1_CI_AS

    3) If 1), then I don't think that SP3 will fix anything. If 2), use the ALTER statement. Latest SP for SQL2005 is SP4, BTW. Service Packs are rolling upgrades and you don't have to apply SP3 and then SP4, you can jump to SP4 directly.

    4) Maybe if your issue is 1), no otherwise.

    -- Gianluca Sartori

  • January 16, 2012 at 2:20 pm

    #1434287

    If you're just trying to change the instance collation, you could read this post:

    http://spaghettidba.com/2011/05/26/changing-server-collation/

    -- Gianluca Sartori

  • January 16, 2012 at 5:22 pm

    #1434365

    thanks,

    I was trying to chanche the collation server without re-install the SQL_Server because when someone create a new object its have a wrong collation... according to our application.

    So I want to change the collation on server

    Is not a problem with a specific database.

  • January 16, 2012 at 5:25 pm

    #1434367

    Thanks, I will try to do it right now.

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

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