great thanks for the info. i have another problem. i'm trying to use a xsd validation again with regular expression, i got the regex from regexlib and it's great when i'm testing the xml using xsd validation tool. but when i try to create xsd collection in sql i got an error.
Msg 102, Level 15, State 1, Line 32
Incorrect syntax near 'year'.
xsd collection attached