DTC 확인 쿼리

SET NOCOUNT ON

DECLARE @DTC_Found INT

CREATE TABLE #output (line NVARCHAR(4000))

INSERT INTO #output
EXEC master..xp_cmd shell N'net start'

SELECT @DTC_Found = COUNT(1) FROM #output WHERE [line] LIKE '%Distributed Transaction Coordinator%'

IF @DTC_Found < 1
BEGIN
    TRUNCATE TABLE #output
    INSERT INTO #output
    EXEC master..xp_cmd shell N'cluster res'
    SELECT @DTC_Found = COUNT(1) FROM #output WHERE [line] LIKE '%MSDTC%Online%'
END

DROP TABLE #output

SELECT @DTC_Found

어디선가 본 DTC 통신 확인 쿼리
되는 경우 1?