How would you do break a huge statement like

delete From tableA

where LHS=RHS

If this tableA is 200 million rows and the delete will have 5 million rows affected how can...

Thanks for the info.

Does -2 inthe blocked always indicate an ORPHAN transaction or only in the case of Distributed Transaction?

Thanks

-Soumil

Thanks for the direction you pointed me into. I was able to set the dbcc traceon (3064) but i was unable to run the DBCC Page command. It comes back...