Loopback linked servers cannot be used in a distributed transaction . Install two SQL Servers in local to solve your problem. Link one instance to another.
http://msdn.microsoft.com/en-us/library/ms188716(SQL.105).aspx
IvanP
- 557
- 1
- 8
- 20