<div>
This is excellent. Just one more minor issue ...<br />
<br />
Any idea how to set to &lt;database default&gt; instead of a specific collation ?<br />
<br />
&nbsp; &nbsp; &nbsp;print ('alter table ' + @strTable + ' Alter column ' + @strcolName + ' ' + @strDataType + @strprecision <br />
&nbsp; &nbsp; &nbsp; &nbsp;+ ' COLLATE ' + ????????????????????????? + ' ' + case when @intNullable = 1 then ' Null ' else ' Not Null' end)<br />
<br />

</div>


This is excellent. Just one more minor issue ...

Any idea how to set to <database default> instead of a specific collation ?

     print ('alter table ' + @strTable + ' Alter column ' + @strcolName + ' ' + @strDataType + @strprecision
       + ' COLLATE ' + ????????????????????????? + ' ' + case when @intNullable = 1 then ' Null ' else ' Not Null' end)



<div>
try changing it to:<br />
<br />
&nbsp;set @strcollateSeq = 'database_default' &nbsp; -- or whatever collation seq you want to use<br />
<br />
/Richard
</div>


try changing it to:

 set @strcollateSeq = 'database_default'   -- or whatever collation seq you want to use

/Richard

<div>
Excellent<br />
<br />
Thanks for helping
</div>


<div>
<div class="content wysiwyg-content">
How can I programmatically (using TSQL) remove the collation sequence from all fields in a database, so that each field has collation sequence &quot;database default&quot; ?<br />
<br />
At the moment most fields have a hard coded collation sequence which is different from the database default, and any fields added by the programs will default to the database default, so there's a collation mismatch on each where clause/join etc. I want to get them the same.<br />
<br />
sql 2000<br />
<br />
thanks<br />

</div>
</div>


How can I programmatically (using TSQL) remove the collation sequence from all fields in a database, so that each field has collation sequence "database default" ?

At the moment most fields have a hard coded collation sequence which is different from the database default, and any fields added by the programs will default to the database default, so there's a collation mismatch on each where clause/join etc. I want to get them the same.

sql 2000

thanks


Reset collation

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.