SQL Server distributed transactions

SQL Server distributed transactions are a little more restrictive than you might think.  Moved an app from 2 database on the same server to the live environment where the two databases were on separate servers.  First had to configure DTS on both machines (setting the security correctly for network distribution).  Then had to remove the explicit nested transaction from the stored procedure which was doing the distributed work.  Then had to change the remote table to have a timestamp field else the cursor wouldn't compile any more.  Its a lot more straightforward in Oracle!