If found the following error while starting my SQL Server 2012 instance, after the update KB3072779 performed by Windows Update (Windows Server 2012 Foundation).
Creating procedure sp_sqlagent_get_perf_counters... 2016-11-14 12:09:07.84 spid5s Error: 468, Severity: 16, State: 9. 2016-11-14 12:09:07.84 spid5s Cannot resolve the collation conflict between "Latin1_General_CS_AS" and "Latin1_General_CI_AS" in the equal to operation.
So now I'm unable to start the SQL Server instance. I managed to run it with
-t902 and perform some queries.
I did check the following:
select name, collation_name from sys.databases
master Latin1_General_CI_AS tempdb Latin1_General_CI_AS model Latin1_General_CI_AS msdb Latin1_General_CI_AS
From what I've read so far, system databases must have the same collation as the server. What I'm not aware of is what happened here and what should I do now.
Did this update change the server collation?
What can I do now to run my instance normally?
EDIT: I finally arrive to solve the problem by following the steps described in one of the links posted by @hot2use