Properties Collection (SQL-DMO)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The Properties collection contains Property objects that expose the attributes of a SQL Distributed Management Objects (SQL-DMO) object property.

SQL-DMO object model that shows the current object

Properties

Count Property

 

Methods

Item Method

 

Remarks

Object properties implement instance data for OLE objects. SQL-DMO is implemented as a dual-interface object library. Its objects are exposed as OLE Automated objects and as COM objects, allowing developers to use either an OLE Automation controller or a C/C++ compiler as an application development platform.

Automation controllers, such as Microsoft Visual Basic, typically enrich the development experience by providing syntax completion and other development aids. Because it exposes the attributes of object properties, the Property object is a central component of automated developer assistance.

When using the Item method, the Properties collection supports member identification using either name or ordinal reference syntax. For example:

Set oProperty = oSQLServer.Properties("Name")

Or:

Set oProperty = oSQLServer.Properties(1)

Note

The Properties collection is implemented for OLE Automation controllers. The C/C++ SQL-DMO application has no direct access to the Property object.

  • Last updated on