title: insert data into queue in sql server service broker
body: <p>I am trying to insert data into queue. The stored procedure fire_event will be used for this purpose. When ever this stored procedure is called, it should insert that data into the queue.. Below is the query and variables that will be passed from the stored procedure. Can some one tell me how to use this stored procedure to insert data in a queue in SQL Server. I want to replace the action of inserting into a table event_type by inserting it directly into a queue. Thanks</p>
  
  <pre><code>BEGIN
  
  INSERT event_type
  VALUES (@p_message_id,@p_event_type,@p_classifier,
          @p_event_time,@p_correlation_id,@p_person_id,@p_channel_id,
          @p_source_address_id,@p_agent_user,
          @p_agent_channel_id,@p_device_os,@p_device_os_version,
          @p_device_manufacturer,@p_device_model,@p_product_id,
          @p_event_source,@p_event_version,
          @p_node_id,@p_user_agent_string,@p_event_data)
  
  END 
  </code></pre>