Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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 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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft