Colin,

Thanks, again, for your response.

>>>I never use estimated plans for debugging btw.<<<

I'll keep that in mind.

>>>Probably a silly question but your proc doesn't start with sp_  ?<<<

There are no silly...

dgentry,

The environment is SQL 2000 SP3 but there is some post-SP3 patch that has not been applied.

Colin,

>>>You say you took most of the code, so what didn't you take? -...

>>> QUOTED_IDENTIFIER and ANSI_NULLS settings <<<

Now that is food for thought.  I use a template for defining stored procedures and it does explicitly set these two values before performing the...

In T-SQL there is no DATE type; only DATETIME.  The CONVERT to a string produces a string (Duh!) but if you convert this string back to a DATETIME, the time...

I don't work with clustered servers (at least not yet), so I tried to look up this info using BOL.  There was nothing listed for the utility in the index. ...

My original proposition was, if I am to be true to myself, sort of a T.I.C. mini-troll.  Just wanted to see if I could roil the waters a bit.  But I'm...

>>>> though I'm sure some will come up with some complaints as usual <<<<

Just 'cause I'd hate for you to be disappointed...

The "correct" answer clearly states that the deleted table...

When I looked at the percentages that people answered, 40% were correct and 10% said None of the above.

Even combining these two, this is still a pretty pathetic percentage to correctly...

I NEVER (well, hardly ever) put anything into the Master database.  I want to keep it as pristine as possible.  The same goes for MSDB. 

I will put things into...