For the record, ColdCoffee's solution was the one I was looking for. I needed something I could wrap into a query, without table functions. The other solution with...

Several nice solutions, and as I suspected simpler than I thought! Thank you all. d lewis

There is an outstanding deconstruction of the challenger mess (the task force was lead by Richard Feynman, an outside the box thinker par excellence) in one of Edward Tufte's books...

Not exactly the question, but we're still running 6.5! It is the core of the system that runs our plant, and the upside of upgrading is insignificant compared to...

All: I've continued to dig into this, and as it turns out some of the assumptions I had made were incorrect. Most importantly, the tables were not static....

I tried this (see attached snip) and no events were captured...

ashutosh.and GSquared:

Execution plans have that kind of data in them. Take a look at event ID 122, for example.

and

I would like to make two suggestions here:-

1. Use cross apply to...

Actually I got it wrong, it is Microsoft SQL Server 2005 - 9.00.5292.00 (X64) Apr 13 2011 15:43:31

Copyright (c) 1988-2005 Microsoft Corporation Standard Edition...

I doubt that this is related but it sounds similar enough that I figure I may as well share. We had an issue where the statistics were out of date...

Correct. The example I sent with...

Also, I forgot to mention that DBCC CHECKDB is run nightly and has not shown any issues. D Lewis

Attached is a spreadsheet with two rows.

The yellow highlighted row is an example of a row that is missing. In the range of records I am looking...

Craig (and others reading):

Here is the stored procedure text. It is very slightly different what I first posted, but not in essence. There are no SET... statements of...

Yes, I really didn't know where to begin.

I don't know if supplying data will really help, because this behavior is not predictable.

But, I can post some if it is...

I think I have found an alternative solution that with some tweaking will work. sp_helptext 'view name here', in conjunction with a temp table, will enable me to strip...