title: What can I do to trace what a program does, not having the source code and the support from the program supplier
body: <p>I have now to deal with a program called <a href="http://fdt.se/" rel="nofollow">FDT</a> whose support is no longer taken by the company I am working for but still using the same program. Now I need to insert new orders into the program from the site which I can get in <code>xml</code>, <code>csv</code> or some other from <code>magento</code>. I am trying to automate this process. All work in the office are done on the basis of this software FDT like checking the out of stock, bills printing and others. </p>
  
  <p>I am now thinking to use <code>profiler</code> to trace events. I would like to know what processing does the program do when we place some order in it. I am not a good user of Profiler, I would like some suggestions if it is possible know what tables it effects, what columns it updates or writes to. </p>
  
  <p>Above it is a new order no. the program generates. which is a unique id and is integer. I am not able to know the pattern. I do have a test server where I can make changes and trial and error is no problem. </p>
  
  <p>Some suggestions on how shall I proceed or at least start going on would be appreciated. </p>
  
  <p>I think most important would be to trace the <code>T-sql</code> but again which events and what filter to use?
  I am sorry if it a stupid question, I am trying to learn .. source code and support is not an option. </p>