| title | SMO and DMO XPs Server Configuration Option | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 06/13/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | configuration |
| ms.topic | conceptual |
| ms.assetid | bcd945ba-5d81-4124-9a2b-d87491c2a369 |
| author | MikeRayMSFT |
| ms.author | mikeray |
| manager | craigg |
Use the SMO and DMO XPs option to enable [!INCLUDEssNoVersion] Management Object (SMO) extended stored procedures on this server.
Note than beginning in [!INCLUDEssSQL11], DMO has been removed from [!INCLUDEssNoVersion].
The possible values are described in the following table:
| Value | Meaning |
|---|---|
| 0 | SMO XPs are not available. |
| 1 | SMO XPs are available. This is the default. |
The setting takes effect immediately.
The following example enables SMO extended stored procedures.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'SMO and DMO XPs', 1;
GO
RECONFIGURE
GO