Listing 2. Code That Checks Whether the MSDTC Service Is Running

DECLARE @MSDTC INT
EXECUTE master..xp_instance_regread
 N'HKEY_LOCAL_MACHINE',
 N'SYSTEM\CurrentControlSet\Services\MSDTC',
   N'Start',@MSDTC OUTPUT
 IF @MSDTC = 3
 PRINT 'PASS' /* Note: 3 = Disabled */