InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 08:33:16 GMT20http://www.sqlservercentral.com/Forums/Topic670940-338-1.aspxBy the way, If you really want to put the XML in your post, you can use one of the following methods: * Replace all "<" and ">" with "[" and "]" * Replace all "<" and ">" with "& lt;" and "& gt;" (except no space) * use the Simple-Talk prettifier here: [url]http://extras.sqlservercentral.com/prettifier/prettifier.aspx[/url]Mon, 09 Mar 2009 08:50:37 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic670940-338-1.aspxWhat have you tried? And what has happened when you tried it? (tell us the error message if there is one)Mon, 09 Mar 2009 08:36:43 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic670940-338-1.aspxpls see the schema attachedMon, 09 Mar 2009 07:43:58 GMTBiswa Mahapatrahttp://www.sqlservercentral.com/Forums/Topic670940-338-1.aspxWe cannot see most of you schema, because the security on these forums will filter out most text that looks like XML or HTML. Please post your XML as an attached file, either as TXT or a ZIP.Sat, 07 Mar 2009 20:59:09 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic670940-338-1.aspxcode snippet:CREATE XML SCHEMA COLLECTION MovieSchema AS N' <xs:schema xmlns="http://schemas.sqlservercentral.com/MovieSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema"> ';GOthis works well but i'm unable to add schema for a attribute called "status" to element "releaseDate". I'm able to add disctype,category to element "film", can anybody suggest/help what i'm missing with.Thanks in advance.Sat, 07 Mar 2009 10:50:27 GMTBiswa Mahapatra