In SQL Server Profiler I have selected the event "Missing Join Predicate" to see if we have any issues with queries missing a join. However, it does not show the query itself. How do you go about capturing the query? Do I need to select another event? Do I need to use another tool?
When you only select this event, it's pretty much guess-work and you have to correlate it by time to the queries that were executed right before this event. If you also select the SQL:StmtCompleted event it should be easier to find out the offending query.
