I have never been able to do that. regardless of MS DTC settings or the sp_configure settings of remote proc trans.....

the way i get around it is using sqlcmd to call a saved .sql file that does the work i need / want.

in this case (you want results of an extended stored procedure).

I would create a .sql file that creates a temp stored procedure to create a table in the tempdb on the remote server and then insert the results of the extended stored procedure into this tempdb table.

once the results are in the remote servers tempdb, i can then just run a select into statement with 4 part naming on the local server to get the data.

if someone else knows how to get around this, I would love to hear about it.