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.
Tags: ,

About author

Vittorio Pavesi

2comments

  1. Anonymous
    6:23 PM

    This was very helpful. Thank you!!

  2. Anonymous
    11:37 AM

    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.

Post a Comment