Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Use the SMO and DMO XPs option to enable SQL Server Management Object (SMO) extended stored procedures on this server.
Note than beginning in SQL Server 2012 (11.x), DMO has been removed from SQL Server.
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
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Configure databases for optimal performance - Training
Configure databases for optimal performance
Documentation
sp_configure (Transact-SQL) - SQL Server
sp_configure displays or changes global configuration settings for the current server.
Administer servers using Policy-Based Management - SQL Server
Learn how to use Policy-Based Management to manage one or more instances of SQL Server.
sys.dm_os_enumerate_fixed_drives (Transact-SQL) - SQL Server
sys.dm_os_enumerate_fixed_drives enumerates volumes mounted to drive letters.