A New Audit

Question

A New Audit

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
February 21, 2024 at 12:00 am

#4374393

Comments posted to this topic are about the item A New Audit
February 21, 2024 at 1:35 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

latkinson SSCommitted Points: 1674 More actions · Answer 1

I guess its a good thing I am not a DBA. Based on the number of questions I have answered incorrectly over the years, any database I managed would be in serious trouble. But, I love trying to answer the question. Even if I get it wrong, I learn something new, and learning new things is what keeps me going. My thanks to all the contributors of these questions.

Luther

david.gugg SSCertifiable Points: 6096 More actions · Answer 2

I'm curious how many DBAs out there use this feature. I have to confess I've been a DBA for 10+ years now and had not heard of it until I saw this question today. In looking through some reference articles on ApexSQL's site, it actually looks fairly handy.

Be still, and know that I am God - Psalm 46:10

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

Steve Jones - SSC Editor

SSC Guru

Points: 736172

February 21, 2024 at 9:34 pm

#4382559

I see it rarely used. I'm sure someone does, but not many

Neil Burton SSC-Insane Points: 22999 More actions · Answer 4

Steve Jones - SSC Editor wrote:

I see it rarely used. I'm sure someone does, but not many

We started "using" it last year. The customer insisted that we enabled it when we migrated and upgraded. I've set it up, turned it on and that's been it. It's just ticking over creating overhead and little usable output. They wanted database auditing aswell so I've got that ticking away too. There's a constant turnover of staff at their end and it's highly likely that the people who requested the auditing have moved on and their replacements don't even know it exists.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

jasona.work SSC Guru Points: 50117 More actions · Answer 5

I work in US FedGov and we're required to have SQL Audits running and basically capturing everything...

I'm also sad to say I got the question wrong, because I let myself over-think my initial answer...