Hello All,
I have a customer that uses three database servers, where two are SQL SERVER EXPRESS 2008 R2 and one is SQL SERVER 2008 R2. I have a couple of stored procedures that use OPENROWSET and OPENQUERY in order to call a procedure within the same database inside
of all three databases, each being called depending on the machine we are running the application from. In order to get the queries to work on SQL SERVER 2008 R2 EXPRESS Edition, I found that I needed to enable the 'Ad Hoc Distributed Queries' by running the
following, as they are not enabled by default:
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO
This gets my queries to work, however I am now having all other queries in my application (with or without using the OPENROWSET) take at least 30 seconds or so to run. This behavior is only present from the two SQL Server Express machines, a ...
Go to the complete details ...