| title | SMO and DMO XPs Server Configuration Option | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | bcd945ba-5d81-4124-9a2b-d87491c2a369 | |
| caps.latest.revision | 15 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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