Link to home
Create AccountLog in
Avatar of ksfok
ksfok

asked on

SQLServer log tables

An article says: "there are lots of options for logging data in SQL Server. The best one depends on what you need to do with the audit logs. Unless you really need them, I recommend against using log tables and triggers. Use the SQL Server log files and a log parser. If you carefully consider all your needs, and decide that a log table is the best way to do it, make sure to take into account the options you have about how and what to log.". Please kindly provide details on how to use the SQL Server log files and a log parser. Thanks.
ASKER CERTIFIED SOLUTION
Avatar of David Todd
David Todd
Flag of New Zealand image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of ksfok
ksfok

ASKER

I guess we are talking about the database transaction log files. Are you saying they can be read only with third party tools and not from inside of SQLserver?
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Hi,

Just a really really small question - why the grade of B? Between myself and AC we completely answered your question.

BTW Lumigent and the like do have the ability to demo the produce - free download that is time-bombed if memory serves me right.

Cheers
  David

PS IF you are able to expand on what you are trying to achieve, we might be able to offer some alternatives.
David,

Did not mean to "steal" your points.  But you are right the grade is unwaranted and obviously the questioner did not like the answer they got and have forgotten the EE maxim "Remember, the Experts helping you today are probably going to be helping you next time you post a question.".  Unfortunately, this is not the first time they do it and they would do well to review the grading guidelines at https://www.experts-exchange.com/help.jsp#hi97

<quote>
Grade Fairly
...
Grading at Experts Exchange is not like school. It's more like the "10-point Must" system in professional boxing; in other words, an answer is worth an A, unless it doesn't resolve your issue. If it requires you to do a little more research, or figure out one more piece of code, then it's worth a B. If you think it's not worth a B, the custom is to offer the Experts an opportunity to earn a better grade.
...

What is the right grade to give?

Although Experts Exchange uses an A-C scale here at Experts Exchange, it works differently than, say, school grades. If one or more Experts' proposals are accepted as answers, they should usually be given an A or B grade, since they have taken the time to provide you with a working solution. If a possible solution is incomplete, ask for clarification or details before accepting the answer and grading it. People should not be given lower grades because of incorrect grammar or because you just accepted their answer or comment to close the question. The following is a good guideline to follow when grading:

A: The Expert(s) either provided you with a thorough answer or they provided you with a link to information that thoroughly answered your question. An "A" can also be given to any answer that you found informative or enlightening beyond the direct question that you asked.
B: The Expert(s) provided an acceptable solution, or a link to an acceptable solution, that you were able to use, although you may have needed a bit more information to complete the task.
...
</quote>

Anthony
Hi Anthony,

I have no problem with the points split and your clarification at all. I often find that something I thought I had expressed completely clearly still left one or two (or more) questions.

I'm just pointing out for the record so to speak, that I believe that our answers should have gotten an A. Just because they point to the difficutl path and say that the proposed shortcut isn't workable, isn't our problem ...

Cheers
  David
>>Just because they point to the difficutl path and say that the proposed shortcut isn't workable, isn't our problem ...<<
I could not agree more.