Need recommendation on simple auditing product.

(SQL Server 2000, SP3a)
Hello all!
A while ago (2 years?) I downloaded a freeware auditing utility called SQLLo
g:
http://www.rlpsoftware.com/SQLLog.asp
It doesn't appear as if the freeware version is available from this site any
more, so I
was hoping to solicit some opinions on a similar utility that would help aud
it database
deletions.
That old SQLLog utility basically put triggers on the desired tables, and sq
uirted XML
into a blob field that would enumerate the fields and their original content
s and any
changed data. It was pretty straightforward and simple to integrate with an
existing
database.
If anyone knows of anything that might be applicable, I'd sure be grateful!
John PetersonI've used SQLAudit and it works well. It basically places triggers on the
tables for you.
SQLAudit
http://www.redmatrix.com/default.asp?section=sqlaudit
I've heard good reports on Lumigent Entegra, but I haven't evaluated that
yet - it's on my to-do list!
http://www.lumigent.com/products/entegra/entegra.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> A while ago (2 years?) I downloaded a freeware auditing utility called
SQLLog:
> http://www.rlpsoftware.com/SQLLog.asp
> It doesn't appear as if the freeware version is available from this site
any more, so I
> was hoping to solicit some opinions on a similar utility that would help
audit database
> deletions.
> That old SQLLog utility basically put triggers on the desired tables, and
squirted XML
> into a blob field that would enumerate the fields and their original
contents and any
> changed data. It was pretty straightforward and simple to integrate with
an existing
> database.
> If anyone knows of anything that might be applicable, I'd sure be
grateful!
> John Peterson
>|||Thanks for the reply, Mark! I was checking out ApexSQL Log as well -- so th
is will be
nice to be able to compare/contrast. I see that Apex's solutions work by re
ading the
transaction log -- so no additional triggers need be in place. That seems l
ike a pretty
clean solution.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:urpHFLQKEHA.1264@.TK2MSFTNGP12.phx.gbl...
> I've used SQLAudit and it works well. It basically places triggers on the
> tables for you.
> SQLAudit
> http://www.redmatrix.com/default.asp?section=sqlaudit
> I've heard good reports on Lumigent Entegra, but I haven't evaluated that
> yet - it's on my to-do list!
> http://www.lumigent.com/products/entegra/entegra.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> SQLLog:
> any more, so I
> audit database
> squirted XML
> contents and any
> an existing
> grateful!
>