Setting Server Configuratio ...


SQL Server 2008 Books Online (October 2009)
SMO and DMO XPs Option

Use the SMO and DMO XPs option to enable SQL Server Management Object (SMO) and SQL Distributed Management Object (SQL-DMO) extended stored procedures on this server.

The possible values are described in the following table:

Value Meaning

0

SMO and SQL-DMO XPs are not available.

1

SMO and SQL-DMO XPs are available. This is the default.

The setting takes effect immediately.

Examples

The following example enables the SMO and DMO extended stored procedures.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'SMO and DMO XPs', 1;
GO
RECONFIGURE
GO
See Also

Other Resources

SQL Distributed Management Objects (SQL-DMO)

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker