title: While reading XML document node elements number of rows differs during run time
body: <p>I have a XML document which is being sent through Pega-Agent. My stored procedure receives the XML and reads the elements.</p>
  
  <p>When I trigger stored procedure manually, 50 rows get affected, however when triggered using Pega-Agent it affects only 11 rows. I tried capturing the XML in a log table and verifying it. Pega-Agent is sending records properly. It is not an upstream issue. It is definitely an issue with SQL Server. But SQL <code>sp</code> when I ran using <code>exec sp sp_name</code> it affects 50 rows.</p>
  
  <p>Is it problem with the account? Is it possible to restrict a user to access only 11 rows from table?</p>