Thanks for the tips everyone, I'll more than likely end up using the OPENROWSET function.

Andrew, I did use the OpenQuery method and I got the same result when I tried to run the query on a different server that's not defined as a linked server...