| title | Server Configuration: SMO and DMO XPs |
|---|---|
| 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. |
| author | rwestMSFT |
| ms.author | randolphwest |
| ms.date | 08/26/2025 |
| ms.service | sql |
| ms.subservice | configuration |
| ms.topic | how-to |
[!INCLUDE SQL Server]
Use the SMO and DMO XPs option to enable [!INCLUDE ssNoVersion] Management Object (SMO) extended stored procedures on this server.
Note than beginning in [!INCLUDE ssSQL11], DMO has been removed from [!INCLUDE ssNoVersion].
The possible values are described in the following table:
| Value | Meaning |
|---|---|
0 |
SMO XPs aren't available. |
1 |
SMO XPs are available. This is the default. |
The setting takes effect immediately.
The following example enables SMO extended stored procedures.
EXECUTE sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXECUTE sp_configure 'SMO and DMO XPs', 1;
GO
RECONFIGURE;
GO