title: How can I tell when a Local Subscription from a Push is used/done?
body: <p>We have a number of local Subscriptions that a vendor uses to Push us data every morning. We're looking to have more info about when this happens and specifically when it finishes using T-SQL.</p>
  
  <p>I tried this:</p>
  
  <pre><code>exec sp_replmonitorsubscriptionpendingcmds 'SQL03', 'RSSPA_Common', 'RSSPA_Common_ORA_Tran', 
      'FBHBGISSQL01', 'RSSPA_Fish', 0
  </code></pre>
  
  <p>but get this message:</p>
  
  <pre><code>Msg 21482, Level 16, State 1, Procedure sp_replmonitorsubscriptionpendingcmds, Line 32
  sp_replmonitorsubscriptionpendingcmds can only be executed in the "distribution" database.
  </code></pre>
  
  <p>How can I tell when this Subscription is being used?</p>