Reputation: 466
When I execute this statement in SSMS (SQL Server 2012):
SELECT * FROM sys.dm_exec_query_stats
the statement fails and it returns about 20 messages saying
Msg 207, Level 16, State 1, Procedure dm_exec_query_stats, Line 11 [Batch Start Line 0] Invalid column name 'total_dop'. Msg 207, Level 16, State 1, Procedure dm_exec_query_stats, Line 11 [Batch Start Line 0] Invalid column name 'last_dop'.
And so on. Can anybody explain what's the problem here? Thanks in advance.
EDIT: Here's a screenshot:
Upvotes: 1
Views: 459
Reputation: 466
SOLVED.
I installed the latest Service Pack and the problem is gone now.
Thank you all for your cooperation and help.
Bliek
Upvotes: 0
Reputation: 294377
Your mssqlsystemresource
database is out of sync. Looks like manual replacement of the resource database in binn
folder, which obviously is not a supported scenario. You must contact MS support to troubleshoot and fix your problem.
Perhaps we can confirm the case, if you run this and post the results:
SELECT SERVERPROPERTY('ResourceVersion');
GO
SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');
GO
Upvotes: 3