Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL Management Objects (SMO)
SMO Managed Programming Reference Documentation
SMO Class Library
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
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
BlockedProcessReport Property
DatabaseMirroringStateChange 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
TraceBroker Property
TraceClr Property
TraceCursors Property
TraceDatabase Property
TraceDeprecation Property
TraceErrorsAndWarnings Property
TraceFileClose Property
TraceFullText Property
TraceLocks Property
TraceObjects Property
TraceOledb Property
TracePerformance Property
TraceProgressReport Property
TraceQueryNotifications Property
TraceScans Property
TraceSecurityAudit Property
TraceServer Property
TraceServerInternalDiagnostics Property
TraceSessions Property
TraceStoredProcedures Property
TraceTransactions 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 2005

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++
VB
Copy 
public bool MissingJoinPredicate { get; set; }
J#
Copy 
/** @property */
public boolean get_MissingJoinPredicate ()

/** @property */
public void set_MissingJoinPredicate (boolean value)
JScript
Copy 
public function get MissingJoinPredicate () : boolean

public function set MissingJoinPredicate (value : boolean)

Property Value

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.

Updated text:

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.


Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Release

History

 Content changed:

  • Description of property has been updated.

Did you find this helpful?
(1500 characters remaining)

Community Additions

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