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
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