ItemByID Method

SQL-DMO

ItemByID Method

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	UserDefinedFunctions Collection
MergeArticles Collection	Users Collection
MergeDynamicSnapshotJobs Collection	Views Collection
MergePublications Collection

Syntax

object.ItemByID( ID ) as Object

Parts

object

Expression that evaluates to an object in the Applies To list

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.

previous page start next page