ItemByID Method

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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

Hinweise

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