如何调试从SQL Server 2008中的Service Broker队列运行的存储过程？

SELECT * FROM sys.service_queues WHERE name = 'your_queue_name';

SELECT * FROM sys.transmission_queue WHERE conversation_handle = your_conversation_handle;

SELECT * FROM sys.procedures WHERE name = 'your_stored_procedure_name';

BEGIN TRY
    -- your stored procedure code here
    DBCC PUTSTACK('your_message_here');
END TRY
BEGIN CATCH
    -- handle errors here
END CATCH

BEGIN TRY
    -- your stored procedure code here
    RAISERROR('your_message_here', 0, 1);
END TRY
BEGIN CATCH
    -- handle errors here
END CATCH

BEGIN TRY
    -- your stored procedure code here
    PRINT 'your_message_here';
END TRY
BEGIN CATCH
    -- handle errors here
END CATCH

BEGIN TRY
    -- your stored procedure code here
    DECLARE @event_id INT = 82;
    EXEC sp_trace_generateevent @event_id, 0, 'your_message_here';
END TRY
BEGIN CATCH
    -- handle errors here
END CATCH

EXEC sp_helptext 'your_stored_procedure_name';

BEGIN TRY
    -- your stored procedure code here
    EXEC sp_refreshsqlmodule 'your_stored_procedure_name';
END TRY
BEGIN CATCH
    -- handle errors here
END CATCH