I have an issue where my SQL server and database collation conflict.
The database collation is correct: "SQL_Latin1_General_CP1_CI_AS"
The server is incorrect "Latin1_General_CI_AS"
I have uninstalled SSQL server and reinstalled and the server collation installs correctly as: ""SQL_Latin1_General_CP1_CI_AS"
If I install a default database we use the server and DB collations match ok.
My issue is when I reattach the required database or restore a backup the system collation changes back to "Latin1_General_CI_AS"???!!
I can't work out why this would happen and I need help to stop this occurring?
I have even tried reattaching with a new database name. So there must be something in the database I am restoring that is changing the system collation?
I haven't tried importing the database yet instead of reattaching or restoring? Not sure if this would work? I have issues with downtime issues whilst trying to fix this to contend with as its a production environment and so hope my last attempt can fix it if I get the right advice.
Your help is much appreciated.