xp_cmdshell sql 2008


In SQL 2008 Surface Area Configuration (SAC) is no more available...


The functionality of Surface Area Configuration for Services and Connections will now be performed by SQL Server Configuration Manager (SQL CM).


Right click server name, click facets and in the facet choose Sql Server configuration manager and configure the xp_cmdshell option.
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

2 comments:

Anonymous said...

This was very helpful. Thank you!!

Anonymous said...

The explanation above says:
SQL Server Configuration Manager (SQL CM).

This is not always correct.

You can go there by SQL CM if you have a fully installed SQL version.
You can find it in Management

Else you have to install the Management Studio (SQL Server Management Studio). Than you can right click on the server name, click Facets and follow the rest of the explanation above.