title: How to give back Transaction status to the user using SQL Server 2012 in C#
body: <p>I am doing migration of data using stored procedure and I want to give user status of migration process. For example if the backup has completed then signal the status of <code>BackUp Completed</code> and so on ....</p>
  
  <p>Here is sample stored procedure</p>
  
  <pre><code>CREATE PROCEDURE sp_Migration
      @id int,
      @camid int,
      @output nvarchar(max) output
  AS
  BEGIN
      begin try
      Begin tran
          /* 1: code for backup */
          exec SP_CollegeBackup
  
          /* 2: code migration */
          exec Sp_studentmigrtion
  
          /* 3: migration finished */
          commit;
      end
      begin catch
           rollback ;
      end
  END
  GO
  </code></pre>
  
  <p>I want to give user back a status update at every step </p>