Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML Validation: Declaration not found for element Expand / Collapse
Author
Message
Posted Saturday, June 21, 2008 9:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 6, 2012 10:08 AM
Points: 78, Visits: 290

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


  Post Attachments 
Error.txt (41 views, 1.30 KB)
Post #521244
Posted Monday, June 23, 2008 9:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 6, 2012 10:08 AM
Points: 78, Visits: 290
Sorry guys, I guess this editor doesnot display xml tags .. So I have attached the code above.

Thanks for your time,
Kayal
Post #521973
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse