| title | SMO and DMO XPs Server Configuration Option | Microsoft Docs |
|---|---|
| description | Learn how to enable SQL Server Management Object (SMO) extended stored procedures on a server. View information on the "SMO and DMO XPs" configuration option. |
| ms.custom | |
| ms.date | 03/02/2017 |
| ms.prod | sql |
| ms.prod_service | high-availability |
| ms.reviewer | |
| ms.technology | configuration |
| ms.topic | conceptual |
| ms.assetid | bcd945ba-5d81-4124-9a2b-d87491c2a369 |
| author | markingmyname |
| ms.author | maghan |
[!INCLUDE SQL Server]
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