Experts help !
I've a FOR XML EXPLICIT query (stored procedure) written in SQL Server 2000. This procedure is called from within a VB.NET program and runs as windows service.
The query has 38 TAGS. It's too big to paste it here....
Once in a while It throws up following error..
Undeclared tag ID 23 is used in a FOR XML EXPLICIT query. - at System.Data.SqlClient.SqlCommand.ExecuteXmlReader()
However if I run the same stored procedure in SQL Analyzer, executes perfect and generates the XML.
As a temporary solution to this problem, I'm recompiling the stored procedure and works fine thereafter.
Any clue what's going ????
thanks
tammi
I've a FOR XML EXPLICIT query (stored procedure) written in SQL Server 2000. This procedure is called from within a VB.NET program and runs as windows service.
The query has 38 TAGS. It's too big to paste it here....
Once in a while It throws up following error..
Undeclared tag ID 23 is used in a FOR XML EXPLICIT query. - at System.Data.SqlClient.SqlCommand.ExecuteXmlReader()
However if I run the same stored procedure in SQL Analyzer, executes perfect and generates the XML.
As a temporary solution to this problem, I'm recompiling the stored procedure and works fine thereafter.
Any clue what's going ????
thanks
tammi