Command (Decision Support Objects)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The Command object in Decision Support Objects (DSO) provides access to commands associated with databases, cubes, and roles in Microsoft® SQL Server™ 2000 Analysis Services. The DSO Database, Cube, and Role objects support the Commands collection for access to associated commands.

All three types of commands are supported with DSO objects. Each command object detailed in the following table uses the Command interface, with the ClassType property set to the appropriate value for the command type as shown.

Command type

Command object

Command class type

Database command

DbCommand

clsDatabaseCommand

Cube command

CubeCommand

clsCubeCommand

Role command

RoleCommand

clsRoleCommand

The Command object is used to:

  • Provide access to the properties, such as the statement and ordinal position, of a command associated with a database, cube, or role.

  • Manage locks for a command associated with a database, cube, or role.