Note, after sp_configure 'remote proc trans',0 and the following reconfigure, close the query analyzer session and start a new one.

Clustered index on Identity column, due to MS automatically creating clustered idx on PK, when that clusteridx is much better on TradeDate or AsOfDate. The whole full vs. simple...