The following script will help you to get all the columns with different collation than the one specified as default for a database.

The following script will help you to get all the columns with different collation than the one specified as default for a database.