WayneS (9/4/2012)
Gianluca,I think I've run across the same limitation, and I've been revamping this script from being process-based to being lock-based. I wanted to add the intra-query parallel processing items, and was having trouble.
I posted a newer script over the weekend, and thanks to Mark's code below, it looks like I'll be having a newer version yet soon.
Thanks for the update!
If you look at the code I posted, you'll see that I used the same technique as Mark. It's incredibly useful when you have to work with multiple nodes at once.
Another thing that I added is the object name lookup on sys.partitions on the originating database.
I was planning to blog it, but I'd be happy to help you with your post instead.
-- Gianluca Sartori