ItemByID Method

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

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.

Sintaxe

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

Comentários

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