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?