Hi All:

Is there a way on setting MSDTC using tsql script? Like you don't have to manually set the services into 'Distributed Transaction Coordinator' and click start/continue button in SQL SERVER SERVICE MANAGER. I have already tried the 'BEGIN DISTRIBUTED TRAN....COMMIT TRAN' w/o setting MSDTC ON in SERVER SERVICE MANAGER however it gives an error message that: MSDTC on server 'NEWJAN\MSSQLCIAS' is unavailable.

Hoping for a quick solution.

Thanks.

Kind Regards,
Jan