XML "Undeclared Tag ID" Error

[Jason Sauer]

We use "FOR XML EXPLICIT" and "OPENXML" heavily on our SQL 2000 Advanced
server. Every now and then we get an "Undeclared Tag ID" error (SQL Error
#6806). If I open the stored procedure, modify it in any way (add a carriage
return, hit the space key) and save it, the error goes away. To my knowledge
we are current on service packs.

Has anyone else had this problem and better still, does anyone know how to
fix it?

Any help would be greatly appreciated.

Thanks!

[Erland Sommarskog]

Jason Sauer (js****@johnsoninv.com) writes:

We use "FOR XML EXPLICIT" and "OPENXML" heavily on our SQL 2000 Advanced
server. Every now and then we get an "Undeclared Tag ID" error (SQL
Error #6806). If I open the stored procedure, modify it in any way (add
a carriage return, hit the space key) and save it, the error goes away.
To my knowledge we are current on service packs.

Has anyone else had this problem and better still, does anyone know how to
fix it?

Never heard of it. It would help if you had a repro, although I can under-
stand that this can be difficult to achieve if it is intermittent.

You try the newsgroup microsoft.public.sqlserver.xml. The people over
have more experience and might have seen it.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Jason Sauer]

Thanks, Erland. I have not visited that group before, but will go there
next.

"Erland Sommarskog" <so****@algonet.se> wrote in message
news:Xn**********************@127.0.0.1...

Jason Sauer (js****@johnsoninv.com) writes:

We use "FOR XML EXPLICIT" and "OPENXML" heavily on our SQL 2000 Advanced
server. Every now and then we get an "Undeclared Tag ID" error (SQL
Error #6806). If I open the stored procedure, modify it in any way (add
a carriage return, hit the space key) and save it, the error goes away.
To my knowledge we are current on service packs.

Has anyone else had this problem and better still, does anyone know how to fix it?

Never heard of it. It would help if you had a repro, although I can under-
stand that this can be difficult to achieve if it is intermittent.

You try the newsgroup microsoft.public.sqlserver.xml. The people over
have more experience and might have seen it.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp