Interesting, thanks.

I have seen the bug about inserting in to a Temp table but pretty much ruled that out.

I'll see what I can find.

Sorry, created in SQL 2008 R2...

m_flagBits = 0x220

Yes I've verified that is the case.

I can't find any 824 errors in the logs though. :ermm:

Great, thanks!

Hmmm. Ok, thanks Derrick.

I will try a few more times, maybe see if I had anything set up differently but I don't think I did.

I appreciate your help anyway,...

quick response!

Well... the long running query is a view and it's returning alot of data as well as processing some of the returned data with a scalar function before outputting....

How strange. Thanks for replying, makes sense.