<div>
Imran,<br />
<br />
Thanks, that looks just the job. &nbsp;I will try it out over the next few days.<br />
<br />
Thanks,<br />
<br />
Ian
</div>


Imran,

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

Thanks,

Ian

<div>
Apologies,<br />
<br />
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.<br />
<br />
Cheers<br />
<br />
Ian
</div>


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

<div>
<div class="content wysiwyg-content">
I have several Dbases with the wrong collation setting and need to correct it. &nbsp;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)?<br />
<br />
<a href="https://www.experts-exchange.com/questions/21078427/change-Collation.html?query=change+collation&clearTAFilter=true" rel="ugc">https://www.experts-exchange.com/questions/21078427/change-Collation.html?query=change+collation&clearTAFilter=true</a><br />
<br />
Is there a better way with SQL2005?<br />
<br />
Thanks,<br />
<br />
<br />
Ian
</div>
</div>


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

SQL Server Collation Query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.