Seconding the response from Guy Yuval-Baharav, MS is very clear that ad-hoc distributed queries are only allowed whe the Ad Hoc Distributed Queries option is set to 0, when set...

My pleasure, happy to help!

While I wish all involved well on this sale, I have to admit that I have some concerns over the sale of this site to Red Gate; 

• Is there any...

My current beastie is a BMW Z4, put away for the winter now while I drive my beater Kia.  This vehicle allows me to...

Sorry George, I tore down our cluster test harness a few weeks back, and I don't expect to set up another for about another 4-6 weeks.  If you have not...

FYI, the article sites ISO6801, I believe the author is referring to ISO8601, and I have certainly run into this same kind of issue in respect to ensuring applications developed...

Well, related to this, I went throught the same kind of problems (and many other people have too), I don't exactly know why the error was caused, but my issue was...