title: How to throw message and commit transaction using RAISERROR?
body: <p>I need to use RAISERROR to throw a message(pop up message) and commit that transaction.Is there any option?</p>
  
  <p>For severity 18 the transaction got rollback.I have changed the severity to 10 and tried like</p>
  
  <pre><code>RAISERROR('Your Reference Number is %s',10,0,@param); 
  </code></pre>
  
  <p>this but it commits the transaction but doesnt show message.
  What i need here is Message has to be thrown and transaction has to be commited</p>
  
  <p>Any suggestion? </p>