title: Can a stored procedure cause a memory leak?
body: <p>We have a sql server 2008 box.
  On this server we have a scheduled job that calls a large stored procedure that opens xml files and loads them into tables. </p>
  
  <p>After an extended period of up time the SQL server consumes literally all the available memory. (in fact the page file nearly ate all the disc space)</p>
  
  <p>Is it possible for a stored proc to leak memory?
  Is it possible for an SSIS package to leak memory?</p>
  
  <p>Thanks in advance!!</p>