title: save for xml path to file
body: <p>I'm tring to save xml result to file in sql server 2008.
  I need this process to happen automatically on each insert/update/delete
  so I'm trying to do it directly in sql management studio via triggers.
  I followed this solution:
  <a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b8d9247e-e6c3-4b70-9b2d-943a863e665b/send-results-of-select-for-xml-query-to-a-file?forum=transactsql" rel="nofollow">http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b8d9247e-e6c3-4b70-9b2d-943a863e665b/send-results-of-select-for-xml-query-to-a-file?forum=transactsql</a></p>
  
  <p>but unfortunately, I keep getting this error when I try to execute:<br>
      "Could not find stored procedure 'dbo.outputxml'."</p>
  
  <p>what is the problem?</p>
  
  <p>I can see the dll and the stored procedure I've created.</p>