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 ...