xml order of nodes in db

[fatbloke]

Hiya

I was wondering why I'm getting a problem with the ordering of xml elements in my project. I have a stored proc which produces an xml definition of a magazine title, then it either stores in an xml field in a sql 2005 db or simply returns the xml. When i compare the xml in the db to the xml returned direct from the stored proc, it should match exactly but it appears that some of the data in the db has been re-ordered - why would this happen? does the insert of the xml into the db somehow re-order the xml or something like that?

cheers
fatbloke

[kows]

you might want to try posting this in the Database Development forum.