SQL-DMO Syntax Conventions

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.

SQL Distributed Management Objects (SQL-DMO) typographical conventions are based on those used in Microsoft Visual Basic reference materials.

Convention Used for


Transact-SQL statements, macro names, and terms used at the operating system level.


Sample command lines and program code.


Information that the user or the application must provide.


SQL-DMO objects; object events, methods, or properties; data types; and other syntax that must be typed exactly as shown.

Automation allows SQL-DMO to expose methods, object properties, events, and constants through intelligent and easy-to-use automation controllers, simplifying the development task.

When using an automation controller, such as Visual Basic, assistance built into the controller exposes SQL-DMO object properties, methods, and events as defined, and prompts for required or optional parameters as part of the development process. When using C or C++, every object property and method appears as an object member function, and the distinction disappears.

The SQL-DMO documentation is directed at the user of an automation controller. Properties are documented as properties, not member functions. Prototypes for SQL-DMO object member functions are included in each topic for the C or C++ developer.

Community Additions