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?