a) 26M is a lot of rows.. are you sure you need that much???

b) size of the row for the selected columns (int = 4, tinyint = 1...)

F) one of...

Can you rerun the query like this and post the actualy text plan?

set showplan_text ON

GO

--select query

GO

set showplan_text off

Hehe, missed an easy one here... Thanx for the correction .

k, it's not the worst case scenario then... the good news is that you'll be able to restore the db next time a problem occurs. you tested the new...

You undertand it just the way I do. The only difference is that your solution is more rigid .

Even a more complete rant that I was gonna do .

Question is irrelevant without context. Also can you come up with an...

Check up sp_addlinkedserver in bols. You'll also have to search on the web to see if it's even possible to do it with that type of db because there's...

while 1 = 1??

This may hang for a while .

Hence .

It's the most accurate guess you could make .

Stupid questions warning : Are you calling the sp from the right db?

Is the sp executing a statement that could fire a trigger, that would try to execute an sp...

I meant, just generate the 50 deletes statement and execute them in the right order.

So how much data was lost in the end?

Can you create a linked server to that type of database? That way you could access all the dbs in the same query (might not be all that fast...

Yes I did and I provided an exemple... better that way so he'll have to understand the code to use it .

As promised...