TSQL - Stored procedure results insertion into table at linked server - No columns or permissions

ISSUE:

The OLE DB provider "SQLNCLI11" for linked server "LINKED_SERVER_NAME_HERE" indicates that either the object has no columns or the current user does not have permissions on that object.

USE THIS METHOD:

insert THESIS.dbo.ExposureCFLM

(

       Field1

       , Field2

       , Field3

)

execute(

 '

       set fmtonly off

       exec DATABASE_NAME_HERE.dbo.STORED_PROCEDURE_NAME_HERE

              @prm1=222

                     , @prm2 = ''aBC''

       ;

') at LINKED_SERVER_NAME_HERE;

 00