We are using a SQL Server 2005 database for our product, one of our client's database some how managed to change its collation. We have a tool that creates the database with its tables and some data with a set collation, but somehow our one client's collation is different. These changes appeared recently, is there a way I can change the collation back? Because at the moment if I try to change it I get dependency errors that stop me from changing it.
Also any idea as to what might have been the cause to these changes?
Thanks in advance