SQL Admin Provider::ListAllDatabases

The ListAllDatabases method allows you to list all databases on a specific SQL server.

Arguments

Remarks

Sample Code

Example XML Request

The following is an example of an XML request for the ListAllDatabases method:

<?xml version="1.0" encoding="iso-8859-1" ?> 
<request>
	<data>
		<serverName>SQL01</serverName>
		<sqlUserName>sampleUser</sqlUserName>
		<sqlUserPass>Pass1Word</sqlUserPass>
	</data>
	<procedure>
		<execute namespace="SQL Admin Provider" 
		 procedure="ListAllDatabases">
		<before source="data" destination="executeData" mode="merge"/>
		<before source="executeData" destination="data" mode="insert"/>
		</execute>
	</procedure>
</request>

Example XML Response

The following is an example of the structure of an XML response for the ListAllDatabases method. The actual returned data will be filled in within the <data> nodes:

<?xml version="1.0" encoding="iso-8859-1" ?>
<response>
	<data>
		<databases>
			<database>
				<name/>
				<db_size/>
				<owner/>
				<dbid/>
				<created/>
				<status/>
				<compatibility_level/>
			</database>
		</databases>
	</data>
</response>

Applies To