SQL-DMO Syntax Conventions

This feature will be removed in the next 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.


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