Hi Abhijit,

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'

, collation_name

FROM sys.columns

WHERE OBJECT_ID IN (SELECT OBJECT_ID

FROM sys.objects

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.

S