title: How to find Stored Procedures execution time in SQL Server?
body: <p>I have 10 stored procedures as follows:
  SP1,SP2,.....,SP10
  These stored procedures do some stuff.
  I need to run these procedures as follows:
  EXECUTE SP1;
  EXECUTE SP2;
  ...
  EXECUTE SP10;</p>
  
  <p>When SQL server finshes to complete execution of these procedures, it gives ten lines showing any row changes caused by all these stored procedures. 
  <strong>What i want to do is that after Execution of all stored procedures SQL Server also gives in output window the execution time for each Stored Procedures.</strong>
  Can i do this? I am sure that for achieving this task i need to modify stored procedures but i don't have any idea how to do it...
  Please help me.
  Thanks.</p>