Deferred prepare could not be completed…awman :(

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 *