DISCOVER_INSTANCES Rowset

  • Article

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