Post reply

Missing Join Predicate

  • August 31, 2006 at 7:18 am

    #113490

    Some developers have been implementing full outer joins, possibly by mistake;

    In profiler I can see the error events "Missing Join Predicate". However, it returns me only the application name and the spid. Clearly, it would be interesting to find the queries or procedures that are behind that.

    Does anybody know of a way to display them?

    Thanks! Regards,

    Jan

  • August 31, 2006 at 8:21 am

    #657818

    you should be able to add objectid and also return the tsql being run - with this info you should be able to track it down.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • August 31, 2006 at 8:48 am

    #657832

    Thanks Colin,

    I have the following Data Columns:

    EventClass

    ObjectID

    TextData

    ApplicationName

    NTUserName

    LoginName

    ClientProcessID

    SPID

    StartTime

    As event I only have "Missing Join Predicate"

    But still I don't see an objectid or Textdata appearing.

    Regards,

    Jan

  • September 5, 2006 at 8:40 am

    #658564

    Jan

    Is there an event immediately before the Missing Join Predicate event with the same SPID that might give you a clue?

    John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply