3 Replies Latest reply on Mar 4, 2009 3:43 PM by bshopp

    TrapVarBinds

    jeff.stewart

      DELETE TrapVarBinds FROM (SELECT TOP 1000 TrapVarBinds.TrapID FROM TrapVarBinds LEFT JOIN Traps ON TrapVarBinds.TrapID=Traps.TrapID WHERE Traps.TrapID IS NULL) AS T1 WHERE(TrapVarBinds.TrapID = T1.TrapID)

      Can someone tell me what this does?  Seems to be eating tons of my SQL resources.

      Thanks.