ItemByID Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ItemByID method extracts a member from a SQL Distributed Management Objects (SQL-DMO) container object such as the Databases collection, using a system-defined component identifier to uniquely identify the container member.

Syntax

object.ItemByID(ID ) as Object

Parts

• object
  Expression that evaluates to an object in the Applies To list.

• ID
  Long integer that specifies a system-generated component identifier.

Returns

A reference to the object extracted

Remarks

The ItemByID method is implemented for SQL-DMO collections containing objects exposing the ID property.

Applies To:

AlertCategories Collection	OperatorCategories Collection
Alerts Collection	Operators Collection
Columns Collection	RemoteServers Collection
Databases Collection	ReplicationDatabases Collection
DBFiles Collection	Rules Collection
Defaults Collection	SQLServers Collection
DistributionArticles Collection	StoredProcedures Collection
FileGroups Collection	Tables Collection
Indexes Collection	TargetServerGroups Collection
JobCategories Collection	TargetServers Collection
JobSchedules Collection	TransArticles Collection
JobSteps Collection	TransPublications Collection
Languages Collection	Triggers Collection
Log Files Collection	UserDefinedDatatypes Collection
MergeArticles Collection	UserDefinedFunctions Collection
MergeDynamicSnapshotJobs Collection	Users Collection
MergePublications Collection	Views Collection
MergeSubsetFilters Collection