Erland Sommarskog <so****@algonet.se> wrote in message news:<Xn**********************@127.0.0.1>...
(fo******@yahoo.co.uk) writes: I want to trace all the selects/deletes/modifys whatever on a database
in an application that are performed in a seperate application.
I need to look into this, any ideas?
- Can triggers do this kind of thing
- Can you somehow access the profiler via OLE or similiar to do this?
- Anything else?
It would probably help if you told us what you want to achieve with this.
If you are into auditing, check out Entegra from Lumgient
(www.lumigent.com.)
If you want to write your Profiler-sort-of-thing, you can use server-side
traces. Look up the sp_trace_xxxx procedures in Books Online.
Its my my own debugging use. I've got a little utility that shows a list
of tables and the records of that table in a DataGrid on the right. I would
like to be able to press a button on that tool, do some database stuff,
then press some other button and see all the tables that have been modified
turn red.
Again, this is just for my own debugging use and I can completely reck the
database if need-be so anything goes.
Thanks for the response, the sp_trace_xxx stuff sounds like what I need. As
I'm new to (relational) databases it would be nice to know what else is
out there that can do this kind of thing. Can you make the database call
a program via some kind of Observer pattern, something else?
I only just learnt about the sysobjects table the other day and thats proved
to be dead useful.