Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue

Opinions?

I've installed all three to try'em out and they all seem to be working
so far, more or less.

Log Explorer has given me a couple of errors but I started over and
continued OK.

ApexSQL Log squawked about "redo for delete cannot be generated for
tables lacking clustered index". Huh? What the...? We have lots of
tables without a clustered index.

I read some reports in Red-Gate's technical support forum about their
product actually bringing down SQL Server. That did not inspire
confidence.

All three install some server-side components like extended stored
proc's which I'm not crazy about and I think all three are server or
instance licensed (does anyone actually purchase more than one license
when it seems like you can easily move any tran log to be analyzed to
the server the product is installed on?). I don't think I'd want to
install any of them on a Production server, at least one that I'm
responsible for!

Thanks,

MartinMartin (mvirta@.olgc.ca) writes:
> ApexSQL Log squawked about "redo for delete cannot be generated for
> tables lacking clustered index". Huh? What the...? We have lots of
> tables without a clustered index.

Probably the people at ApexSQL are like me: they think that every table
should have a clustered index.

If nothing else, fragmentation is easier to keep in check, if you have
a clustered index.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Log / Audit

Hi All,
I want to log all activities happening in SQL server. I already know
some auditing tools do it like:
1- DB Audit
2- ApexSQL
Also I activated SQL server audit log and all of them are helpful but,
the problem is they couldn't capture table fields that users see (not
update/delete/add that trigger stored procedures).
I need to see which fields accessed by stored procedures/users/web
pages and then log this activity.
One possibility I am thinking is to change one of system stored
procedures or add some trigger there and log activity from that point.
I appreciate any reply or help to this question
Thanks,
JackHi
DON'T change system stored procedures. In your case you will have to use
third party tools as you mentioend or writing triggers on ALL user tables
that my hurt performance considerable
<question_123_question@.yahoo.com> wrote in message
news:1182988761.219792.164300@.i38g2000prf.googlegroups.com...
> Hi All,
> I want to log all activities happening in SQL server. I already know
> some auditing tools do it like:
> 1- DB Audit
> 2- ApexSQL
> Also I activated SQL server audit log and all of them are helpful but,
> the problem is they couldn't capture table fields that users see (not
> update/delete/add that trigger stored procedures).
> I need to see which fields accessed by stored procedures/users/web
> pages and then log this activity.
> One possibility I am thinking is to change one of system stored
> procedures or add some trigger there and log activity from that point.
> I appreciate any reply or help to this question
> Thanks,
> Jack
>