GTTools.com

Since I work as a consultant I always bring with me my “toolbox”. My latest addition to this toolbox is a SQL Server script created by Narayana Vyas Kondreddi
He has created a script that let you export your data, by generating a insert script, from a given table in a very easy way.
All you [...]

If you for some reason needs to change the collation of a column in SQL Server to the default database collation, you can use the following syntax:
ALTER TABLE <table_name> ALTER COLUMN <column_name> <current_data_type> COLLATE database_default
Eg.:
ALTER TABLE myTable ALTER COLUMN myColumn TEXT COLLATE database_default