I have changed the collation of test database using the follwoing query:
USE master; GO ALTER DATABASE test COLLATE SQL_Latin1_General_CP1_CI_AI ; GO --Verify the collation setting. SELECT name, collation_name FROM sys.databases WHERE name = N'test'; GO
Now when I want to compare a columns of test database against test2 database, I receive the following error:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I have checked that both databases has
SQL_Latin1_General_CP1_CI_AI collation in :
Management studio > Database > properties > options > collation.
Is there another option rather than the database itself (e.g. schema) which still holds the old collation?