Deferred prepare could not be completed…awman :(

15_The_Superhuman_Gambit

Your hero for the day!

The solution was deceptively simple and my own nub fault.

I was using the following query:
SELECT a.* FROM OPENQUERY(LINKEDSERVERNAME, ‘SELECT * FROM DBNAME.TABLENAME’) a

Corrected to:

SELECT a.* FROM OPENQUERY(LINKEDSERVERNAME, ‘SELECT * FROM DBNAME.dbo.TABLENAME’) a

Cheers

5 comments

  1. Actually, probably worth replacing 'dbo' in your solution with 'SchemaName'. The 'dbo' reference will only work where the schema of the referenced table is actually dbo.Still love your work 😉

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.