I have a Linked Server that I need to generate reports from two databases, is it possible to use the query builder with a linked server? I have not found a way to do this, I would expect to select Linked Server as the data source. Thanks.

I usually just use OPENROWSET function referenced in the FROM clause of a query in the current data source. http://msdn.microsoft.com/en-us/library/ms190312.aspx Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]

I usually just use OPENROWSET function referenced in the FROM clause of a query in the current data source. http://msdn.microsoft.com/en-us/library/ms190312.aspx Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]