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