• Install the ASSP assembly on the AS instance (http://asstoredprocedures.codeplex.com/)

    Then run the following:

    CALL ASSP.DiscoverXmlMetadataFull("\Databases\Database")

    That's the only way I know of to look at it programatically unless you start querying the file system from SQL.


    I'm on LinkedIn