title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
SMO and DMO XPs (server configuration option)	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.	rwestMSFT	randolphwest	03/02/2017	sql	configuration	conceptual

SMO and DMO XPs (server configuration option)

[!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.

Examples

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