>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
xp_cmdshell 'net start "Distributed Transaction Coordinator"'