Post reply

Collation Sequence Changing (850 to 1252)

  • August 11, 2003 at 8:49 am

    #59302

    I plan on changing the collation sequence on our main production server as I move to to a new machine in the next few weeks. It is SQL2000. I want to go from SQL_Latin1_General_Pref_CP850_CI_AS to SQL_Latin1_General_CP1_CI_AS (850 to 1252). Here's how I would like to do it:

    1. alter database dbname collate SQL_Latin1_General_CP1_CI_AS

    2. update syscolumns set collationid = 872468488

    where collationid = 721473544

    My question is: Does anyone see any possible dificulties in doing this? I have tested this already and have not had any issues this far, but my testing so far has not been all-encompasing yet. I realize that this is not a "supported" way of doing this, so I am not interested in any "warnings", only facts on why this will/will not work.

    Thanks!

    Francis
    -----------------
    SQLRanger.com

  • August 14, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • August 14, 2003 at 5:48 pm

    #470040

    I could only think of "warnings" (in which fapel isn't interested). I have no facts on why it wouldn't work. I can only strongly recommend following documented MS procedure, especially on a "main production server", if continued MS support is a future requirement.

    Cheers,

    - Mark


    Cheers,
    - Mark

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

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