Changing SQL Server Collation After Installation

(Douglas P. Castilho) In some scenarios we might find different SQL Server collations between the server instance and its databases. Sometimes the collation is fixed in some table columns or inside stored procedures to solve relationship problems with columns that have different collations.