Tracking data update in a database

Question

Tracking data update in a database

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 1

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).

Ross McMicken SSCarpal Tunnel Points: 4531 More actions · Answer 2

+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.