|
Home > Archive > MS SQL Server > November 2005 > audit tool
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| hongo32 2005-11-30, 11:23 am |
| hello, i listen that exists many tools for register all the changes
made to the tables, for audit purpouses, can somebody recommend to me
what options exists... ? exists free option?
| |
| David J. Cartwright 2005-11-30, 11:23 am |
| but english broken kiks
"hongo32" <hongo32es@yahoo.com> wrote in message
news:1133366598.263720.93150@f14g2000cwb.googlegroups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>
| |
| hongo32 2005-11-30, 11:23 am |
| sorry, i don't understand.... what i want its a tool that track all the
insert, update, delete made in the tables,.... and register them in
other database.... this tools exists?
| |
| hongo32 2005-11-30, 11:23 am |
| a tool diferent to sql profiler... more eficient...
| |
| Adam Machanic 2005-11-30, 11:23 am |
| SQL Server does have built-in audit modes (C2 auditing), but I've never
actually turned it on. You might want to read up on that a bit.
I believe Idera's SQL Compliance Manager does this kind of thing, as well.
I'm not aware of any free options.
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@yahoo.com> wrote in message
news:1133366598.263720.93150@f14g2000cwb.googlegroups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>
| |
| hongo32 2005-11-30, 11:23 am |
| thanks, and sorry for my english... i talk spanish... bye
| |
| Adam Machanic 2005-11-30, 11:23 am |
| De nada.
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@yahoo.com> wrote in message
news:1133368401.530605.263290@g43g2000cwa.googlegroups.com...
> thanks, and sorry for my english... i talk spanish... bye
>
| |
| hongo32 2005-11-30, 11:23 am |
| its better idera than log pi? (www.logpi.com)
| |
| Adam Machanic 2005-11-30, 11:23 am |
| That's not really the same kind of tool. LogPI, Log Explorer, and Log
Rescue can't really report on what happened -- they're used by DBAs after
problems occur to try to undo the damage.
What do you really need to do with a tool? Report for compliance purposes
to management, or fix problems?
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@yahoo.com> wrote in message
news:1133369158.956440.322830@g47g2000cwa.googlegroups.com...
> its better idera than log pi? (www.logpi.com)
>
| |
| Simon Worth 2005-11-30, 11:23 am |
| hongo32 wrote:
> its better idera than log pi? (www.logpi.com)
>
If you're only interested in update, delete, and inserts on user tables
then use triggers to manage the audit trail. However, if you're
interested in schema changes then you cannot create triggers on system
tables and will need to find a different solution.
However, if you're using SQL Server 2005 you can create database
triggers to track these changes for auditing.
| |
| hongo32 2005-11-30, 1:23 pm |
| i'm looking for other solutions... because this solution offer better
performance than a trigger... that i want is an audit tool... i ask for
logPI because someone toll me about it... thanks for your commentaries
|
|
|
|
|