I'm using this config, trying to find error when a certain host executes a task ( it runs inside a software ):
The user says that the software is running, but it's not updating what it needs to update.
So, I'm tracking their queries and procs, to find some errors.
Is this correct? If I use this:
select * from table where
It shows me an error ( that's what I want ).
Do you guys use something different? Is this a good way to find errors using trace? I use HOSTNAME with his machine.
Again, it's working. I just would like to know some other tips.
Thank you very much.