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 executes a number of Windows command-line calls from
stored procedures in the database.
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.)

Answer:

Explanation:

Note:
You would need administrator permission.
The xp_cmdshell option is a server configuration option that enables system administrators
to control whether the xp_cmdshell extended stored procedure can be executed on a
system. —- To allow advanced options to be changed.
EXEC sp_configure ‘show advanced options’, 1 GO —- To update the currently configured
value for advanced options. RECONFIGURE GO —- To enable the feature. EXEC
sp_configure ‘xp_cmdshell’, 1 GO