changing collation

  • Hi,

     

    I'm looking to change the collation on one of my databases so it can talk to another database on our server.  Is there a quicker way of doing this other than creating a new database with the correct collation and copying the tables across to new database?

    Your help would be much appreciated

     

    Cheers

  • This was removed by the editor as SPAM

  • You can specify the collation in your SQL Statements.  You would have to do it for every statement though, so it might end up being more work.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

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

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