Option 1 - CREATE XML SCHEMA COLLECTION XXX AS ‘…’
Option 3 - Use other free and non-free third party
tools (see http://stackoverflow.com/questions/74879/any-tools-to-generate-an-xsd-schema-from-an-xml-instance-document)
Option 4 - In BIDS 2005+, copy the xml code from
SSMS to the xml editor window in VS or BIDS, from the XML menu, choose Generate
Schema. See below for details: