DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database installed along with the default
settings.
You want to migrate a database from a SQL Server 2000 server that is being
decommissioned. The application instantiates ActiveX objects from stored procedures in the
database by using sp_OACreate.
You need to configure SQL Server 2008 R2 to allow command-line calls from this database.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Explanation:
Note:
* Use the Ole Automation Procedures option to specify whether OLE Automation objects can
be instantiated within Transact-SQL batches. This option can also be configured using the
Policy-Based Management or the sp_configure stored procedure. The Ole Automation
Procedures option can be set to the following values. 0 OLE Automation Procedures are
disabled. Default for new instances of SQL Server. 1 OLE Automation Procedures are
enabled. When OLE Automation Procedures are enabled, a call to sp_OACreate will start
the OLE shared execution environment.