Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL Server Management Objects (SMO) Class Library
Microsoft.SqlServer.Management.Smo Namespace
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
This topic has not yet been rated - Rate this topic

ServerTraceEventSet.MissingJoinPredicate Property

SQL Server 2008 R2

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a query that has no join predicate is being executed.

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether the MissingJoinPredicate 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.

Monitoring this event is useful because queries with no join predicate can result in long-running queries.

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

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