
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
Actually this works for me:SELECT a.* FROM OPENQUERY( LinkedServerName , 'SELECT * FROM DBNAME.dbo.TABLENAME') a
Thanks for catching the typo. Updated
No problem, love your work 😉
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 😉
LOL…let's not make it too easy for them! 🙂