It’s a simple tip how to solve some issues caused by Collation inconsistences.
/*Selecting your DB*/
/*Select all object which are different from SQL_Latin1_General_CP1_CI_AS – Put here what collation you are looking for. */
SELECT name, collation_name, *
WHERE OBJECT_ID IN (SELECT OBJECT_ID
WHERE type = ‘U’ )
and collation_name ‘SQL_Latin1_General_CP1_CI_AS’
/* Change the database collation */
ALTER TABLE TableName
ALTER COLUMN ColumnName NVARCHAR(6)
COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
Easy, isn’t it?
Sorry but I’m so lazy now to format those SQL scripts 😛