The SqlQueryDiscoveryType complex type, in Configuration Manager 2007, describes discovery information for settings discovered from Microsoft SQL Server 2000 and SQL Server 2005.

<xs:complexType name="SqlQueryDiscoveryType">
	<xs:complexContent>
		<xs:extension
			base="DiscoverySourceType"
		>
			<xs:sequence>
				<xs:element name="Instance"
					type="SqlInstanceNamePattern"
					minOccurs="0"
					maxOccurs="1"
				 />
				<xs:element name="Database"
					type="NonEmptyStringType"
				 />
				<xs:element name="Query"
					type="SqlQueryStringType"
				 />
				<xs:element name="ColumnName"
					type="NonEmptyStringType"
				 />
			</xs:sequence>
		</xs:extension>
	</xs:complexContent>
</xs:complexType>

Child Elements

Element Type Description

ColumnName

NonEmptyStringType

The name of the column whose values will be retrieved from the result set returned in the preceding Query. This can be case sensitive depending upon the case sensitivity of the instance of SQL Server that is being connected to.

Database

NonEmptyStringType

The name of the database in the specified instance of the SQL Server to connect to. This can be case sensitive depending upon the case sensitivity of the instance of SQL Server that is being connected to.

Instance

NonEmptyStringType

The name of the SQL Server instance to connect to for discovery.

If the element is not specified, the default instance is assumed.

If the element is specified and the value is ‘*’, all instances are enumerated and each is queried.

Query

SqlQueryStringType

T-SQL query string that must be executed on the specified database instance. This must be a well formed T-SQL query.

See Also

Send comments about this topic to Microsoft.