SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Collation Checker

By paul_richardson,

this a quick sproc I put together to do various collation checks.
databases that have different collations from server
databases that have different collations of columns within
databases that have column collations different from database collation

Total article views: 1909 | Views in the last 30 days: 15
Related Articles

Different collation

Different collation


Show all database's tables' columns' collations.

Created view displays all text columns' collations in the current database with the information whet...


I thought my database was collation agnostic

My struggles with a customer's database that used a different collation sequence. The easy way is n...


Server and user databases using different collations

Change server and system databases collation, leaving user databases as is


Collation question for sql 2005

2 databases with different collations.