>>Server collation and database collation and column collation is not the same thing. You can have SQL Server case insensitive (and you should have), but have case-sensitive database or certain columns to be case sensitive. Of course, this would be set in design time (or can be altered), so by default database inherits the same collation as model database.
>
>The database is set up insensitive and the default is preserved for the related items.
Good, I was just explaining that it's possible to have different collations within the same database for different columns.
If it's not broken, fix it until it is.
My Blog