title: How to check that a stored procedure with no return value has been executed?
body: <p>I am executing a stored procedure that has no return value. How can I check that it has actually been executed? Here is the code:</p>
  
  <pre><code>this.dbProviderFactory = DalFactory.GetFactory(this.adapterConfiguration);
  DbConnection dbConnection = dbProviderFactory.CreateConnection();
  
  dbConnection.ConnectionString = this.adapterConfiguration.DatabaseInformation.ExternalDatabaseInformation.connectionString;
  dbConnection.Open();
  
  DbCommand cmd = dbConnection.CreateCommand();
  cmd.CommandText = "h_AS_SP_ResetUnfinishedJobs";
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>And here is the stored procedure:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[h_AS_SP_ResetUnfinishedJobs]
  AS
  BEGIN
   -- Delete all unfinished jobs where the force flag has not been set...
   DELETE FROM h_AS_mds_MetaDataStatus
   WHERE mds_status NOT IN (11,12) AND mds_force = 0
  END
  </code></pre>