Fins Out What Data Is Being Written To A Database

Associate
Joined
25 Feb 2007
Posts
905
Location
Midlands
Hi,

Are there any tools or techniques available which can monitor a database and display any data being written to it?

I'm trying to find out what data is added to/amended in a database by a program, so my idea is to have something sit between the it and it's db, and then perform the action in the program.

Is this possible?

This is using SQL Server 2005.

Thanks,
 
Last edited:
Yeah sounds like what you want is SQL profiler, I think its a tool thats on every instance of SQL management studio from 2005 onwards. I cant remember the exact way to get to it, will just check...
 
It was simple, Tools then SQL profiler, its the top option for me. it will initially show you everything thats happening to a DB but you can use the filters and such like to get rid of the crap you dont want and fine tune it to display exactly the processes you want. Its basically a SQL trace.

If you google it then im sure there will be some useful page on how best to use it, happy profiling!
 
Back
Top Bottom