SQL Server Collation Query

I have several Dbases with the wrong collation setting and need to correct it.  Please can anyone confirm if the solution provided in this Article from 2004 is still the best way of doing it (i.e. use a SQL Script to recreate the Dbase and BCP to export then import the data)?

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21078427.html?query=change+collation&clearTAFilter=true

Is there a better way with SQL2005?

Thanks,


Ian
LaserformSupportAsked:
Who is Participating?
 
imran_fastCommented:
Check this microsoft article

http://support.microsoft.com/kb/325335
0
 
LaserformSupportAuthor Commented:
Imran,

Thanks, that looks just the job.  I will try it out over the next few days.

Thanks,

Ian
0
 
LaserformSupportAuthor Commented:
Apologies,

We have not yet had the resources available to try these suggestions but will post back as soon as we have, it will be in the next few days.

Cheers

Ian
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.