What's the possible reason why OpenQuery is not working
What are the possible reason that an openquery stops functioning: INSERT INTO #someTempTable SELECT * FROM OPENQUERY(SOMELINKEDSERVER, "exec DB.dbo.uspProc") -- or even this line doesnt work. While fully qualified linked servers like: INSERT INTO #someTempTable exec SOMELINKEDSERVER.DB.dbo.uspProc works? **Updated**: fully qualified on the OpenQuery as well, what's odd is that was working previously. Now it only works w/ fully qualified execution.
You say that the query doesn't work - what error are you getting, if any? Looking at your example, your OPENQUERY doesn't seem to be qualifying the database and schema, where the linked server version does.