Missing Join Predicate SQL2005

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?
Who is Participating?
imran_fastConnect With a Mentor Commented:
hi feiza,
Its more like a warning ..
Aneesh RetnakaranDatabase AdministratorCommented:
Did you try running the trace ?
feizaAuthor Commented:
Yes and nothing have show up so far, but in other systems we have the same issue, auto generated traces with Missing Join Predicate
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.
feizaAuthor Commented:
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?...
All Courses

From novice to tech pro — start learning today.