October 12, 2008 at 8:22 am
Our accounting package creates records in our database for invoices, credit notes......etc. I want to write an app in vb that will create one of these such documents outside of the package.Is there a way I can set something to watch the current state of the database , create a document with our accounting package and then go back into sql to see exactly what records it created and what it changed?
October 12, 2008 at 8:58 am
You can use Profiler, probably the easiest way for large scale tracking of things. It will record all SQL run against the database (you can limit it by user/login).
October 13, 2008 at 5:23 am
+1 on profiler. I use profiler all th etime to determine what vendor apps are doing. I do recommend doing this on a test server, as it's easier to isolate the data you want. On a production server, it can be difficult to capture the desired data, especially if the app uses SQL authentication, and uses a common ID for all operations.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply