Export (0) Print
Expand All

DISCOVER_INSTANCES Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft