SQL Server
United States (English)
Sign in
Home 2014 2012 2008 R2 2008 Previous Versions Library Forums
Export (0) Print
Expand All
TechNet Library
SQL Server
SQL Server 2014
Product Documentation
Developer Reference for SQL Server 2014
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
ServerTraceEventSet Class
ServerTraceEventSet Properties
AssemblyLoad Property
AuditAddDBUserEvent Property
AuditAddloginEvent Property
AuditAddLoginToServerRoleEvent Property
AuditAddMemberToDBRoleEvent Property
AuditAddRoleEvent Property
AuditAppRoleChangePasswordEvent Property
AuditBackupRestoreEvent Property
AuditChangeAuditEvent Property
AuditChangeDatabaseOwner Property
AuditDatabaseManagementEvent Property
AuditDatabaseObjectAccessEvent Property
AuditDatabaseObjectGdrEvent Property
AuditDatabaseObjectManagementEvent Property
AuditDatabaseObjectTakeOwnershipEvent Property
AuditDatabaseOperationEvent Property
AuditDatabasePrincipalImpersonationEvent Property
AuditDatabasePrincipalManagementEvent Property
AuditDatabaseScopeGdrEvent Property
AuditDbccEvent Property
AuditFulltext Property
AuditLogin Property
AuditLoginChangePasswordEvent Property
AuditLoginChangePropertyEvent Property
AuditLoginFailed Property
AuditLoginGdrEvent Property
AuditLogout Property
AuditSchemaObjectAccessEvent Property
AuditSchemaObjectGdrEvent Property
AuditSchemaObjectManagementEvent Property
AuditSchemaObjectTakeOwnershipEvent Property
AuditServerAlterTraceEvent Property
AuditServerObjectGdrEvent Property
AuditServerObjectManagementEvent Property
AuditServerObjectTakeOwnershipEvent Property
AuditServerOperationEvent Property
AuditServerPrincipalImpersonationEvent Property
AuditServerPrincipalManagementEvent Property
AuditServerScopeGdrEvent Property
BitmapWarning Property
BlockedProcessReport Property
CpuThresholdExceeded Property
DatabaseMirroringStateChange Property
DatabaseSuspectDataPage Property
DataFileAutoGrow Property
DataFileAutoShrink Property
DeadlockGraph Property
DeprecationAnnouncement Property
DeprecationFinalSupport Property
Errorlog Property
Eventlog Property
Exception Property
ExchangeSpillEvent Property
ExecutionWarnings Property
FtCrawlAborted Property
FtCrawlStarted Property
FtCrawlStopped Property
HashWarning Property
LockDeadlock Property
LockDeadlockChain Property
LockEscalation Property
LogFileAutoGrow Property
LogFileAutoShrink Property
MissingColumnStatistics Property
MissingJoinPredicate Property
MountTape Property
NumberOfElements Property
ObjectAltered Property
ObjectCreated Property
ObjectDeleted Property
OledbCallEvent Property
OledbDatareadEvent Property
OledbErrors Property
OledbProviderInformation Property
OledbQueryinterfaceEvent Property
Qn_dynamics Property
Qn_parameterTable Property
Qn_subscription Property
Qn_template Property
ServerMemoryChange Property
ShowplanAllForQueryCompile Property
ShowplanXml Property
ShowplanXmlForQueryCompile Property
ShowplanXmlStatisticsProfile Property
SortWarnings Property
SpCacheinsert Property
SpCachemiss Property
SpCacheremove Property
SpRecompile Property
SqlStmtrecompile Property
TraceAllEvents Property
TraceClr Property
TraceDatabase Property
TraceDeprecation Property
TraceErrorsAndWarnings Property
TraceFileClose Property
TraceFullText Property
TraceLocks Property
TraceObjects Property
TraceOledb Property
TracePerformance Property
TraceQueryNotifications Property
TraceSecurityAudit Property
TraceServer Property
TraceStoredProcedures Property
TraceTsql Property
TraceUserConfigurable Property
Userconfigurable0 Property
Userconfigurable1 Property
Userconfigurable2 Property
Userconfigurable3 Property
Userconfigurable4 Property
Userconfigurable5 Property
Userconfigurable6 Property
Userconfigurable7 Property
Userconfigurable8 Property
Userconfigurable9 Property
UserErrorMessage Property
XqueryStaticType Property
Expand Minimize

ServerTraceEventSet.ShowplanAllForQueryCompile Property

SQL Server 2014

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an SQL statement compiles and displays complete, compile-time data.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

C#
C++
F#
JScript
VB
Copy 
public bool ShowplanAllForQueryCompile { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether the ShowplanAllForQueryCompile event is included in the event set.If True, the event is included in the event set.If False (default), the event is not included in the event set.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft