• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

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
0
LaserformSupport
Asked:
LaserformSupport
  • 2
1 Solution
 
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now