Depending on taste, SQL Server Profiler or xp_trace stored_procedure family.
Bothe are fully covered in Books Online. The filters available to you seem
to vary a little by choice of tool. SQL Server Profiler would enable you to
filter by the specific error conditios; alternatively user, application or
host can be used - in combination if needed.

> -----Original Message-----
> From: Shawn Smith (William) [SMTP:[Email Address Removed] Sent: Wednesday, March 13, 2002 5:38 PM
> To: '[Email Address Removed] '[Email Address Removed] Subject: missing join predicate
>
> We are experiencing latency with one of the applications. Network is fine.
> I
> ran a trace and found one spid with alot of missing join predicate errors,
> but no detail. How can I find what this spid is doing? And would this
> cause
> problems or is it something else?
>
> Shawn Smith
> Database Administrator
> Fort Worth Star-Telegram
> 817-390-7094
> 817-291-5240 cell
> 817-667-2757 pager
> [Email Address Removed]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page