> From: Metadata Object Description Schema List [mailto:[log in to unmask]] On
> Behalf Of Meisam Hasani
> Sent: Saturday, June 21, 2008 11:54 PM
> To: [log in to unmask]
> Subject: [MODS] mods in sql server 2005
> step 1: I created a "xml schema collection" for this schema
> step 2: create table books_mods ( id int primary key identity, xml_data
> mods ))
> step 3: insert into books_mods values("...content of this url
> http://www.loc.gov/standards/mods/v3/mods85753651.xml ...")
> in "step 3" created this error "XML parsing: line 1, character 118,
> undeclared prefix" .
It has been a while since I used the XML support in SQL server, but I think I ran into a problem when an XML schema imports another XML schemas, like mods-3-0.xsd does. I think you must also load the imported schemas into SQL server's XML schema collection too.