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

OLE DB for OLAP Schema Rowsets