• I figured out a way to workaround this problem:

    - Change the Linked Server settings to RPC available

    - Run the query something like, EXEC(@SQL) AT [LinkedServer]