changing collation

• mark lake

  Say Hey Kid

  Points: 702

  More actions

  July 1, 2005 at 6:41 am

  #93410

  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

• July 4, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Derrick Leggett

  SSCrazy

  Points: 2778

  More actions

  July 4, 2005 at 11:31 am

  #570723

  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.