Thanks for the reply.
So if i cant find any dependacies on columns with the different collation i could do a simple ALTER DATABASE?
Am i on the right track trying the following:
SELECT DISTINCT OBJECT_NAME (OBJECT_ID) AS 'Table Name'
,name AS 'Column Name'
WHERE OBJECT_ID IN (SELECT OBJECT_ID
WHERE TYPE = 'U')
AND collation_name IS NOT NULL
ORDER BY OBJECT_NAME (OBJECT_ID)
To find any tables in the database that have a collation set.
and run this against all the tables from that list to find if they have any dependacies?
SELECT * FROM sys.sql_expression_dependencies
WHERE referencing_id = X
If none of the tables have dependancies I can just change it with ALTER and im good to go?
Sorry for the confusion.