SQL SERVER : How To Change Collation for all DataBase Table Columns.

Change Collation for all Database Tables columns: Here in this article will see how we can modify the collation of our database tables column. In our previous article have explained how we can find the collation of database with a simple SQL Script in SQLSERVER 2008 R2. Here in this example, we set or alter collation all database columns as SQL_Latin1_General_CP1_CI_AS with the below-written query.

The reason behind changing the collation of database column in SQL Server?

I was working with a SQL query, and this SQL query joined two tables from 2 different Database SERVER (SQL SERVER ). While executing that SQL query we got below written error

Cannot resolve the collation conflict between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS in the equal to operation.

So we came to know that both the SQL SERVER DataBase has different collation, i.e., each table, and each column has the different collation.