SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Database Engine
Database Engine Features and Tasks
Database Engine Instances (SQL Server)
Configure Database Engine Instances
Server Configuration Options (SQL Server)
access check cache Server Configuration Options
ad hoc distributed queries Server Configuration Option
affinity I/O mask Server Configuration Option
affinity64 I/O mask Server Configuration Option
affinity mask Server Configuration Option
affinity64 mask Server Configuration Option
Agent XPs Server Configuration Option
allow updates Server Configuration Option
View or Configure the backup compression default Server Configuration Option
blocked process threshold Server Configuration Option
c2 audit mode Server Configuration Option
clr enabled Server Configuration Option
common criteria compliance enabled Server Configuration Option
contained database authentication Server Configuration Option
Configure the cost threshold for parallelism Server Configuration Option
Configure the cursor threshold Server Configuration Option
cross db ownership chaining Server Configuration Option
Database Mail XPs Server Configuration Option
Configure the default full-text language Server Configuration Option
Configure the default language Server Configuration Option
default trace enabled Server Configuration Option
disallow results from triggers Server Configuration Option
EKM provider enabled Server Configuration Option
filestream access level Server Configuration Option
Configure the fill factor Server Configuration Option
ft crawl bandwidth Server Configuration Option
ft notify bandwidth Server Configuration Option
in-doubt xact resolution Server Configuration Option
Configure the index create memory Server Configuration Option
lightweight pooling Server Configuration Option
Configure the locks Server Configuration Option
Configure the max degree of parallelism Server Configuration Option
max full-text crawl range Server Configuration Option
Configure the max text repl size Server Configuration Option
Configure the max worker threads Server Configuration Option
Configure the media retention Server Configuration Option
Configure the min memory per query Server Configuration Option
Configure the nested triggers Server Configuration Option
Configure the network packet size Server Configuration Option
Ole Automation Procedures Server Configuration Option
open objects Server Configuration Option
optimize for ad hoc workloads Server Configuration Option
PH timeout Server Configuration Option
precompute rank Server Configuration Option
Configure the priority boost Server Configuration Option
Configure the query governor cost limit Server Configuration Option
Configure the query wait Server Configuration Option
Configure the recovery interval Server Configuration Option
Configure the remote access Server Configuration Option
remote admin connections Server Configuration Option
Configure the remote login timeout Server Configuration Option
Configure the remote proc trans Server Configuration Option
Configure the remote query timeout Server Configuration Option
Replication XPs Server Configuration Option
Configure the scan for startup procs Server Configuration Option
Server Memory Server Configuration Options
server trigger recursion Server Configuration Option
set working set size Server Configuration Option
show advanced options Server Configuration Option
SMO and DMO XPs Server Configuration Option
transform noise words Server Configuration Option
Configure the two digit year cutoff Server Configuration Option
Configure the user connections Server Configuration Option
Configure the user options Server Configuration Option
xp_cmdshell Server Configuration Option
Expand Minimize
This topic has not yet been rated - Rate this topic

SMO and DMO XPs Server Configuration Option

SQL Server 2012

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, 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.

Copy 
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'SMO and DMO XPs', 1;
GO
RECONFIGURE
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.