Thanks samalex. This doesn't really work for my situation though. These servers are in very different geographical locations and there is too much data to try to do this with a linked server.