That word is banned from my dictionnary untill next week .

I never said it was a problem... Just an extra step to know about.

BAD, BAD, BAD... No application should be designed that way It will be felt really hard at maintenence schedules!

He's already feeling that one .

CURSORS...

Strange... there should have been something in the blkby column...

Anyways glad you got this worked out.

Third one is not as important as the 2 others, so I can take 2 weeks off that one.

Still not getting into that third one.

That's my life. Work and pool. There's no other way to become pro .

"both for licensing and stability reasons."

And sanity . This seems to be very complexe. Are you sure it's not possible to...

HTP

Hit the poolroom (hard) .

How long does it take to query another table?

Sorry to hear that. Looks like you're stuck with this situation. Good luck with that.

Start the query in one window of QA.

Then run this in another window : exec sp_who2

check the column blkby.

Then for each row showing something different that "-"

run dbcc inputbuffer (spid).

That'll...

Oops, I thaught it meant happy to help .

You're right. I'm reffering to the select into part.

You never know when this task will need to be done in the day. That's why I'd stay away from...

Check if there are any open transaction. Any lock on any table (specially system tables).