Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: SQL collation problem

    Hi all,

    All my servers have a default collation of Latin1_General_CPI_CI_AS. Apart from one that is. It was rebuilt with the wrong collation of Latin1_General_CI_AS. This is causing problems with an application and the collation needs to be changed to be the same as all the other servers.

    I know I could create scripts for all the objects, rebuild the master database, recreate the user databases and then create the objects and BCP all the data over, but this sounds a bit nasty.

    Can anyone suggest a quicker and easier way to accomplish this?


    P.S. The server that was wrongly built was done so before I started this job, honest.

  2. #2
    Join Date
    Nov 2002
    I would script the database using the version 7 option

    dump out all the data

    rebuild the box

    run the script

    bcp the data back in


    But that's just me

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts