<div>
Did you try running the trace ?
</div>


<div>
Yes and nothing have show up so far, but in other systems we have the same issue, auto generated traces with Missing Join Predicate 
</div>


Yes and nothing have show up so far, but in other systems we have the same issue, auto generated traces with Missing Join Predicate

<div>
Missing Join Predicate: Indicates whether or not the query in question has a join predicate. If not, this can cause the Query Optimizer to produce a less than optimized query plan. To fix this, add a join predicate. <br />
<br />
Run sql profiler to identify this query.
</div>


Missing Join Predicate: Indicates whether or not the query in question has a join predicate. If not, this can cause the Query Optimizer to produce a less than optimized query plan. To fix this, add a join predicate.

Run sql profiler to identify this query.

<div>
I have ran SQL profiler for hours and nothing show up in this trace, now it show up in a trace than I presume is been autogenerated by SQL, any ideas?...<br />
thanks
</div>


I have ran SQL profiler for hours and nothing show up in this trace, now it show up in a trace than I presume is been autogenerated by SQL, any ideas?...
thanks

<div>
<div class="content wysiwyg-content">
I'm getting a Missing Join Predicate (W2K3/SP1 SQL2005 ) in a trace generated by the system (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG),<wbr /> how to find out what querry is causing it?<br />

</div>
</div>


I'm getting a Missing Join Predicate (W2K3/SP1 SQL2005 ) in a trace generated by the system (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG), how to find out what querry is causing it?


Missing Join Predicate SQL2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.