We have a SQL Server 2014 instance, which houses many related databases. New ones are added via our script regularly. When our app is used to create the database - the databases are created with collation SQL_Latin1_General_CP1_CI_AS
as expected.
But there are now databases with Latin1_General_CI_AS
collation. They were not created by our app (we looked at the database creator). For example, "Pete" is the db owner and some DBs he created would have Latin1_General_CI_AS
collation and others SQL_Latin1_General_CP1_CI_AS
.
Can anyone point out what I could investigate please - should the default collation not always be the same as the SQL instance? What if I created a database remotely - from PC1 with Collation1 and PC2 with Collation2 - would the database be created with different collations?
Any ideas how this could happen - multiple collations for one user? Thanks