A. This error message is put in the SQL errorlog at startup if the
MSDTC service isn't running/configured. Unless you are using DTC this is
More details on DTC can be found in the SQL Server Books Online. (BOL)
A. No, you have to code your own sp. Here is some sample code ...
A. You can have both installed at the same time and switch between
them, but there is no way for both to be running at the same time.