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

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.