• 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')