XML Validation: Declaration not found for element

  • Sorry guys, I guess the code was not added to my last post. So I am attaching it this time.

    I am running into an issue using SQL Server 2005 while trying to use an XML Schema to Validate XML data to be inserted into a table. Any help in solving this issue would be greatly appreciated.

    I receive this error:

    Msg 6913, Level 16, State 1, Line 1

    XML Validation: Declaration not found for element 'Additional'. Location: /*:Additional[1]

    Please find attached the XML code and the insert statement i am using:

    Thanks,

    Kayal

  • Sorry guys, I guess this editor doesnot display xml tags .. So I have attached the code above.

    Thanks for your time,

    Kayal

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply