Bliek
Bliek

Reputation: 466

sys.dm_exec_query_stats returns 'invalid column name'

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:

enter image description here

Upvotes: 1

Views: 459

Answers (2)

Bliek
Bliek

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

Remus Rusanu
Remus Rusanu

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

Related Questions