ID Property (SQL-DMO)

The ID property exists for Microsoft® SQL Server™ database, agent, and replication components with defined identifiers.

Applies To

Alert Object	MergeArticle Object
Category Object	MergePublication Object
Column Object	MergeSubsetFilter Object
ConfigValue Object	Operator Object
Database Object	RemoteServer Object
DBFile Object	Rule Object
DBObject Object	StoredProcedure Object
Default Object	Table Object
DistributionArticle Object	TransArticle Object
DistributionPublication Object	TransPublication Object
FileGroup Object	Trigger Object
Index Object	User Object
Language Object	UserDefinedDatatype Object
LogFile Object	View Object

Syntax

object.ID

Part	Description
object	Expression that evaluates to an object in the Applies To list

Remarks

The definitions of many SQL Server database, agent, and replication components are implemented as records in SQL Server system tables. Within a system table, one column may be designated as an identifier. An identifier is a value that is unique for all rows in the table. Identifiers are assigned by SQL Server.

The ID property represents a SQL Server component identifier and, by using the ItemByID method, provides an alternate method for selecting a specific SQL-DMO object from its containing collection.

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetID(LPLONG plID);