Home Forums SQL Server 2008 Working with Oracle LINKED SERVER to NETEZZA QUESTION RE: LINKED SERVER to NETEZZA QUESTION
anwar.mir
SSC Journeyman
Points: 87
More actions
October 28, 2015 at 4:34 am
#1835974
Remove the square brackets and ensure all your tables in the Openquery string
SELECT *
FROM OPENQUERY([LINKED_SERVER], 'SELECT * FROM DATABASE.SCHEMA.TABLE LIMIT 10')