Fixed, thanks for the warning.

Not yet, the details are being queried, awaiting for reply. Will update later.

For what I've read so far (links and the short examples Marios provided), I guess I have to issue the following commands:

EXEC sp_trace_setstatus @traceid=@traceid_returned_by_creator_script, @status = 2;

EXEC sp_trace_setstatus...

The trace is already running, but it can only catch the villain :alien: after 'committing' 😀 the crime. And it causes log backups to be missing. I'm willing to spend...

Good idea. Though the last two occasions when the plans went awry were at completely different times of day and none of the scheduled jobs were run at that time...

Shawn Melton (2/22/2011)

---

What version of SQL are you running? According to BOL: allow updates Option. This setting has no effect starting in SQL Server 2005. The command should fail when...

Thank you very much, Perry, that should do the job. Besides, I've learnt a bunch of things from it, I've just started using the Profiler.

Two more questions though.

How...

Unfortunately, I'm stuck with MS SQL 2000 (Desktop Engine). I found a note in Books Online (2008 R2) stating that "To use APPLY, the database compatibility level must be at...

I agree with JL 🙂 By the way, the typo is still not corrected...

...ehh, irrelevant... 🙂