sp_databasesXML

This stored procedure will list the names of all databases (or "qualifiers") to which the Microsot SQL Engine currently has access. Note that the internal SCHEMA database is not included, but is always available. The output is in XML format.

call sp_databasesXML()

call sp_databasesXML();

<?xml version="1.0" standalone="no"?>

<SQLEngineDatastoreSchema>

<database name="EnumDB" owner="dbo">

</database>

<database name="RTDB" owner="dbo">

</database>

</SQLEngineDatastoreSchema>