OpenQuery does not accept variables for its arguments. To use dynamic parameters, you must construct the entire query string dynamically and execute it via EXEC(). Tip Use OpenQuery when interacting ...
Executes the specified pass-through query on the specified linked server. This server is an OLE DB data source. In a query, use OPENQUERY in the FROM as if it were a table name. You can also reference ...
I've got an ASP.NET app w/ a SQL backend. The SQL backend has a linked server (Access db) that is has several views that call from the linked tables. Everything works fine in QA and Enterprise manager ...