title: Stored procedure history and what application is calling it?
body: <p>I was given the batch work to research our 200 stored procedures and find out a bunch of different information about them. Is there anyway in SQL Server 2012 to pull execution history on stored procedures? Also is there anyway to tell what application might be calling the stored procedure? Even an IP address would be helpful because we have several server that do various processing.</p>
  
  <p>Any information you can provide me about this would be extremely helpful. I am relatively new to this type of thing in SQL. Thanks!</p>