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
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
Configuration Class
Configuration Properties
AdHocDistributedQueriesEnabled Property
Affinity64IOMask Property
Affinity64Mask Property
AffinityIOMask Property
AffinityMask Property
AgentXPsEnabled Property
AllowUpdates Property
AweEnabled Property
BlockedProcessThreshold Property
C2AuditMode Property
CommonCriteriaComplianceEnabled Property
ContainmentEnabled Property
CostThresholdForParallelism Property
CrossDBOwnershipChaining Property
CursorThreshold Property
DatabaseMailEnabled Property
DefaultBackupCompression Property
DefaultFullTextLanguage Property
DefaultLanguage Property
DefaultTraceEnabled Property
DisallowResultsFromTriggers Property
ExtensibleKeyManagementEnabled Property
FilestreamAccessLevel Property
FillFactor Property
FullTextCrawlBandwidthMax Property
FullTextCrawlBandwidthMin Property
FullTextCrawlRangeMax Property
FullTextNotifyBandwidthMax Property
FullTextNotifyBandwidthMin Property
IndexCreateMemory Property
InDoubtTransactionResolution Property
IsSqlClrEnabled Property
LightweightPooling Property
Locks Property
MaxDegreeOfParallelism Property
MaxServerMemory Property
MaxWorkerThreads Property
MediaRetention Property
MinMemoryPerQuery Property
MinServerMemory Property
NestedTriggers Property
NetworkPacketSize Property
OleAutomationProceduresEnabled Property
OpenObjects Property
OptimizeAdhocWorkloads Property
PrecomputeRank Property
PriorityBoost Property
Properties Property
ProtocolHandlerTimeout Property
QueryGovernorCostLimit Property
QueryWait Property
RecoveryInterval Property
RemoteAccess Property
RemoteDacConnectionsEnabled Property
RemoteLoginTimeout Property
RemoteProcTrans Property
RemoteQueryTimeout Property
ReplicationMaxTextSize Property
ReplicationXPsEnabled Property
ScanForStartupProcedures Property
ServerTriggerRecursionEnabled Property
SetWorkingSetSize Property
ShowAdvancedOptions Property
SmoAndDmoXPsEnabled Property
SqlMailXPsEnabled Property
TransformNoiseWords Property
TwoDigitYearCutoff Property
UserConnections Property
UserInstancesEnabled Property
UserInstanceTimeout Property
UserOptions Property
WebXPsEnabled Property
XPCmdShellEnabled Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Configuration.AgentXPsEnabled Property

SQL Server 2012

Gets the ConfigProperty object that is used to set the agent XPs enabled configuration option.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
public ConfigProperty AgentXPsEnabled { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the agent XPs enabled configuration option.

The AgentXPsEnabled property sets the agent XPs enabled configuration option. This property is used to enable the SQL Server Agent extended stored procedures.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.