If you plan on using distributed transactions then Yes.
In my environment, I had to configure it to enable insert-exec over linked server.
Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]