Loading an XML Schema Collection from a File
A commonly asked question is "how can I load an existing XSD file into an XML Schema Collection?" It's pretty easy:
declare @don xml
select @don=bulkcolumn from openrowset(bulk 'c:\users\ktegels\some.xsd',single_blob) as s
create xml schema collection dbo.collectionName as @don
go
Subsituting the location for your file following the BULK provider in the OpenRowSet source.