Undeclared Tag Error in SQL

J

Jason Sauer

We use "FOR XML EXPLICIT" and "OPENXML" heavily on our SQL 2000
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.

We are starting to get the error a few times a day in different stored
procedures.
Has anyone else had this problem and better still, does anyone know how to
fix it?

Any help would be greatly appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,768
Messages
2,569,574
Members
45,050
Latest member
AngelS122

Latest Threads

Top