There is a Linked Server Called LSName
This Linked Server is Responding to test OK.

If I run:
exec LSName.Dbname.dbo.EDB_sp_fu_Notification 800

This returns a Recorset Ok.

But I need to Insert this Data into a Temp Table or a Cursor to Process the Data Obtained.

Then I Create a Temp Table Called INSERT #TTB_NOTIFICATION with the Structure Equal to the Recordset that will be Returned

When I am Trying to run the Next Instruction:

INSERT #TTB_NOTIFICATION
exec LSName.Dbname.dbo.EDB_sp_fu_Notification 800

The system shows this error:

OLE DB provider "SQLNCLI" for linked server "LSName" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "LSName" was unable to begin a distributed transaction.


Running this command
SELECT * FROM OPENQUERY(LSName, 'Dbname.dbo.EDB_sp_fu_Notification 1')

Returns this error:
Msg 7357, Level 16, State 1, Line 1
Cannot process the object "Dbname.dbo.EDB_sp_fu_Notification 1". The OLE DB provider "SQLNCLI" for linked server "LSName" indicates that either the object has no columns or the current user does not have permissions on that object.

Any sugestion to suppress the error Message?
Better if the suggestion does not involve changes at the Linked Server