Log Files

Hello All,
Is there anyway I can read logfiles programatically (or non-programtically
using non-third-party tools)' I need to read
logfiles to know what transaction happened to a particular record, is there
anyway'
Thanks in advance
--
Maher K. Al-Jendasi
Privacy and Confidentiality Notice:
The information contained in this electronic mail message is intended for
the named recipient(s) only. It may contain privileged and confidential
information. If you are not an intended recipient, you must not copy,
forward, distribute, or take any action in reliance on it.
If you have received this electronic mail message in error, please notify
the sender immediately.Please nto cross posting, answered in .programming.
Jens Süßmeyer.
"Maher K. Al-Jendasi" <mkaljendasi@.hotmail.com> schrieb im Newsbeitrag
news:#iwDh74eDHA.1736@.TK2MSFTNGP12.phx.gbl...
> Hello All,
> Is there anyway I can read logfiles programatically (or non-programtically
> using non-third-party tools)' I need to read
> logfiles to know what transaction happened to a particular record, is
there
> anyway'
> Thanks in advance
>
> --
> Maher K. Al-Jendasi
> Privacy and Confidentiality Notice:
> The information contained in this electronic mail message is intended for
> the named recipient(s) only. It may contain privileged and confidential
> information. If you are not an intended recipient, you must not copy,
> forward, distribute, or take any action in reliance on it.
> If you have received this electronic mail message in error, please notify
> the sender immediately.
>
>|||LogExplorer made by Lumigent (www.lumigent.com) will read the log files, and
much more.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Maher K. Al-Jendasi" <mkaljendasi@.hotmail.com> wrote in message
news:#iwDh74eDHA.1736@.TK2MSFTNGP12.phx.gbl...
> Hello All,
> Is there anyway I can read logfiles programatically (or non-programtically
> using non-third-party tools)' I need to read
> logfiles to know what transaction happened to a particular record, is
there
> anyway'
> Thanks in advance
>
> --
> Maher K. Al-Jendasi
> Privacy and Confidentiality Notice:
> The information contained in this electronic mail message is intended for
> the named recipient(s) only. It may contain privileged and confidential
> information. If you are not an intended recipient, you must not copy,
> forward, distribute, or take any action in reliance on it.
> If you have received this electronic mail message in error, please notify
> the sender immediately.
>
>

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
>

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
>

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,
Jack
Hi
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.googlegr oups.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
>