Instantiating the provider outside the SQL Server process protects the SQL Server process from errors in the provider. When the provider is instantiated outside the SQL Server process, updates or ...

Linked Server Properties: Options Dynamic parameter Indicates that the provider allows '?' parameter marker syntax for parameterized queries. Set this option only if the provider supports the ...

That server then breaks down the query (exactly as your server did) and passes whatever SQL it needs to whatever linked servers it has.

I don't know if we have a config incorrect or what.We have a stored procedure that does some selects to import data from tables and views on a linked SQL Server.Lately, every once in a while, the ...