Hello all. Couldn't find anything specific to this situation so apologies in advance if it has been covered. My situation is this:
I have a 2012 SQL environment that was created using the default collation of "SQL_Latin1_General_CP1_CI_AS" and, of course, all the system db's would have that collation as well. After creation, some user databases were restored to it as part of a migration from another 2012 SQL instance. Those user (application) databases had a collation of "Latin1_General_BIN". There were some issues as one would expect where some procedures were experiencing "collation mismatch" errors around things created in tempdb.
I therefore used the steps outlined in an article at mssqltips to change the collation of the system dbs (and instance db according to the article) to match the collation of the other user dbs (i.e. set them to be Latin1_General_BIN). This worked fine with the exception of the instance collation which did not get changed. It is still at the default.
So, my question: what is the impact of having every database on the instance including the system dbs be the same except for the sql instance itself. Appreciate the input.