Deferred prepare could not be completed…awman :(

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

Anonymous says:

November 10, 2011 at 4:12 pm

Actually this works for me:SELECT a.* FROM OPENQUERY( LinkedServerName , 'SELECT * FROM DBNAME.dbo.TABLENAME') a

Reply
Tim M. Hidalgo says:

November 10, 2011 at 4:20 pm

Thanks for catching the typo. Updated

Reply
Anonymous says:

November 10, 2011 at 4:48 pm

No problem, love your work 😉

Reply
Anonymous says:

November 10, 2011 at 4:50 pm

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 😉

Reply
Tim M. Hidalgo says:

November 10, 2011 at 5:02 pm

LOL…let's not make it too easy for them! 🙂

Reply