start MSDTC with a command

• sql_2005_fan

  SSCommitted

  Points: 1871

  More actions

  March 8, 2011 at 12:00 pm

  #236248

  Is there any command to start MSDTC service?

  Thanks.

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  March 8, 2011 at 12:28 pm

  #1296080

  try xp_cmdshell 'sc start MSDTC'

• sql_2005_fan

  SSCommitted

  Points: 1871

  More actions

  March 8, 2011 at 12:39 pm

  #1296085

  After I started MSDTC do I need to restart the server?

  Thanks.

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  March 8, 2011 at 12:50 pm

  #1296093

  The sql service must be started after msdtc is started.