Click here to monitor SSC
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 Version 2

By paul_richardson,

this is version 2 of a quick sproc I put together to do various collation checks.

now excludes offline databases (using state <> 6 from sys.databases)

checks are :-


databases that have different collations from server
databases that have different collations of columns within
databases that have column collations different from database collation

run by :-

exec sp_collation_checker

Total article views: 966 | Views in the last 30 days: 2
 
Related Articles
FORUM

Different collation

Different collation

SCRIPT

Show all database's tables' columns' collations.

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

ARTICLE

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...

FORUM

Server and user databases using different collations

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

FORUM

Collation question for sql 2005

2 databases with different collations.

Tags
miscellaneous    
 
Contribute