List columns where collation doesn't match database collationhttp://sqlblog.com/blogs/tibor_karaszi/archive/2012/05/23/list-columns-where-collation-doesn-t-match-database-collation.aspxBelow script lists all database/table/column where the column collation doesn't match the database collation. I just wrote it for a migration project and thought I'd share it. I'm sure lots of tings can be improved, but below worked just fine for me forenCommunityServer 2.1 SP2 (Build: 61129.1)re: List columns where collation doesn't match database collationhttp://sqlblog.com/blogs/tibor_karaszi/archive/2012/05/23/list-columns-where-collation-doesn-t-match-database-collation.aspx#43612Mon, 28 May 2012 05:32:06 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43612Uri Dimant<p>Thank you Tibor, very useful script.Usually, in the past I got SQLDMO object library to script out objects without collation (Const SQLDMOScript2_NoCollation As Long = 8388608) so running on the dest. server will defaut database collation</p>