TechNet
Export (0) Print
Expand All

DISCOVER_INSTANCES Rowset

 

Applies To: SQL Server 2016 Preview

Describes the instances on the server.

The DISCOVER_INSTANCES rowset contains the following columns.

Column nameType indicatorLengthDescription
INSTANCE_NAMEDBTYPE_WSTRThe name of the instance.
INSTANCE_PORT_NUMBERDBTYPE_I4The port number the instance listens on.
INSTANCE_STATEDBTYPE_I4The state of the server instance:

 Started

 Stopped

 Starting

 Stopping

 Paused

This schema rowset is not sorted.

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

Column nameType indicatorRestriction State
INSTANCE_NAMEDBTYPE_WSTROptional.

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft