Execute the set_databaseXML stored procedure

This stored procedure will list the names of all databases (or qualifiers) to which the Microsoft SQL Engine currently has access. The output is in XML format.

Note: The internal SCHEMA database is not included, but is always available.

ODBC Syntax

call sp_databasesXML()

Example

call sp_databasesXML();

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

<SQLEngineDatastoreSchema>

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

</database>

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

</database>

</SQLEngineDatastoreSchema>