Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

XML parsing duplicate attribute Error

59 views
Skip to first unread message

M A Srinivas

unread,
Nov 30, 2009, 3:59:38 AM11/30/09
to
Following query ,emits error

SELECT TOP 1000 total_worker_time/execution_count AS [Avg CPU Time],
deqp.dbid,deqp.objectid,deqp.number,deqp.encrypted
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) deqp
GO

-- Error SQL Server 2008 Developer SP1
Msg 9437, Level 16, State 1, Line 1
XML parsing: line 1, character 3312, duplicate attribute


-- Error SQL Server 2005 Developer SP2
Msg 9437, Level 16, State 1, Line 1
XML parsing: line 1, character 1513, duplicate attribute

Erland Sommarskog

unread,
Nov 30, 2009, 5:15:34 PM11/30/09
to
You could try using dm_exec_query_plan_text instead. It is possible
for an XML plan to go beyond what the xml data type supports.


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

0 new messages