This topic has not yet been rated - Rate this topic

DISCOVER_INSTANCES Rowset

SQL Server 2008 R2

Other Versions

Describes the instances on the server.

The DISCOVER_INSTANCES rowset contains the following columns.

Column name	Type indicator	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

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:

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions