연구개발/Service Broker

Service Broker 큐에서 사용하는 내부 테이블 이름 확인

HEAD1TON 2011. 8. 24. 02:02
SELECT Q.name AS QueueName, I.name AS InternalName
FROM sys.service_queues AS Q
    JOIN sys.internal_tables AS I
        ON Q.object_id = I.parent_object_id;