DISCOVER_INSTANCES Rowset

Describes the instances on the server.

Rowset Columns

The DISCOVER_INSTANCES rowset contains the following columns.

Column name	Type indicator	Length	Description
INSTANCE_NAME	DBTYPE_WSTR		The name of the instance.
INSTANCE_PORT_NUMBER	DBTYPE_I4		The port number the instance listens on.
INSTANCE_STATE	DBTYPE_I4		The state of the server instance: Started Stopped Starting Stopping Paused

This schema rowset is not sorted.

Restriction Columns

The DISCOVER_INSTANCES rowset can be restricted on the columns listed in the following table.

Column name	Type indicator	Restriction State
INSTANCE_NAME	DBTYPE_WSTR	Optional.

See Also

Reference

OLE DB for OLAP Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance