Question regarding SQL Server 2005 query logging
Posted on 2009-04-09
Bit of an SQL Server novice here, so I appreciate any help you can give me. Skip to the very end if you want a summary of the solution I'm looking for, otherwise feel free to read on for the full explanation.
Essentially, here's my situation: we have a third party windows application for processing customer orders (that come from our ecommerce platform) and this application utilizes an sql server 2005 express database, and we wrote our own application to parse a csv export of our ecommerce orders and insert it into this shipping application.
Here's the problem: the shipping application has a filter system to filter data, e.g., "show me all orders processed yesterday." Well, the filters dont currently work; they simply show 0 results, even where results should be shown.. And I'm sure it's a record/possibly a foreign key constraint or some kind that just isn't being updated properly by our import app, because if you go into the shipping application and try to edit an order, and simply hit ok without making any changes of any kind, the order will then show up on the filter. So whatever query is firing via the third party shipping application when you hit "ok" on that order edit, is fixing the problem.
So what I'd like to do is find a way to write all sql server queries to a log, so that I can see what query is firing when I hit that "ok" button in the 3rd party ship app and fix the problem in our code where appropriate. I know how/where to do this in MySQL, but I'm not familiar with the option in sql server '05.
Short version: how do I turn on complete logging for all queries sent to sql server, and where do I view those logs at?
Thanks in advance.