ItemByID Method (SQL-DMO)

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

Applies To

AlertCategories Collection	MergeSubsetFilters Collection
Alerts Collection	OperatorCategories Collection
Columns Collection	Operators Collection
ConfigValues 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
Jobs Collection	TransArticles Collection
JobSchedules Collection	TransPublications Collection
JobSteps Collection	Triggers Collection
Languages Collection	UserDefinedDatatypes Collection
Log Files Collection	Users Collection
MergeArticles Collection	Views Collection
MergePublications Collection

Syntax

object.ItemByID( ID ) as Object

Part	Description
object	Expression that evaluates to an object in the Applies To list
ID	Long integer specifying 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.