We help IT Professionals succeed at work.

SQLServer log tables

216 Views
Last Modified: 2013-12-08
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.
Comment
Watch Question

Senior Database Administrator
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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?
CERTIFIED EXPERT
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
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.
CERTIFIED EXPERT
Top Expert 2012

Commented:
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
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
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
CERTIFIED EXPERT
Top Expert 2012

Commented:
>>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.

Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.