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.

An object of ClassType clsDatabaseCommand provides a specific implementation of the Decision Support Objects (DSO) Command interface. This object provides collections, methods, and properties through the Command interface.

An object of ClassType clsDatabaseCommand encapsulates a user-defined command that is automatically executed on the Microsoft® SQL Server™ 2000 Analysis Services client when the database containing the command is accessed. You add a command to a database by adding it to the database's Commands collection. Such commands include calculated members, named sets, library references, and others.

Use the following code to create an object of ClassType clsDatabaseCommand:

'Assume an object (dsoServer) of ClassType clsServer exists
'with an existing database
Dim dsoDB As DSO.MDStore      'Database
Dim dsoCmd As DSO.Command   'Command

Set dsoDB = dsoServer.MDStores(1)
Set dsoCmd = dsoDB.Commands.AddNew("DBCmd1")

Community Additions

© 2015 Microsoft