SQLServerCentral / Discuss Content Posted by Steve Jones / Article Discussions / Article Discussions by Author / SQL Audit / Latest Posts

RE: SQL Audit

Jamie Longstreet-481950 — Sat, 17 Jul 2010 16:50:30 GMT

Maybe, because there is confusion over C2 audit?LimitationsThe main limitation of the auditing is that it reduces the performance of the SQL Server. This happens due to saving the every action to the file. Second limitation is the hard disk space. These auditing files grow rapidly, which will reduce the disk space. According to the C2 , if it is not able to write to the trace file, SQL Server will be shutdown.http://sqlhelpguide.wordpress.com/2009/07/01/basics-of-c2-auditing/

RE: SQL Audit

UMG Developer — Fri, 16 Jul 2010 10:22:53 GMT

I figured you were testing short-term recall to see if people still remembered what they learned. ;-)

RE: SQL Audit

Jan Sorenson — Fri, 16 Jul 2010 09:32:24 GMT

Deja-vu I think Steve saw the movie "Inception" and has gotten into our dreams, where he has manipulated our dreams thinking that we have already had this questions but we really haven't. Thanks for the bonus point.;-)

RE: SQL Audit

Steve Jones - SSC Editor — Fri, 16 Jul 2010 08:34:05 GMT

Apologies, we must have had a scheduling error out there. Still, a free point for everyone.

RE: SQL Audit

KWymore — Fri, 16 Jul 2010 07:44:29 GMT

Thanks for the freebie! Happy Friday everyone!

RE: SQL Audit

Tom Garth — Fri, 16 Jul 2010 07:04:13 GMT

EASY MONEY!!!This time:-P.

RE: SQL Audit

Daniel Bowlin — Fri, 16 Jul 2010 06:42:38 GMT

[quote][b]CavyPrincess (7/16/2010)[/b][hr]I had to research it the first time. At least this time, I knew the answer. My biggest excitement - actually remembering something "all the way" back to July 9 :)Cindy[/quote]That is one of the great things about this site. Even if in this case by accident, you keep coming here and new knowledge gets reinforced and you start to get a deeper understanding of how to use everything. Just this week I used 2 things I learned on SSC in production.:cool:

RE: SQL Audit

OCTom — Fri, 16 Jul 2010 06:29:44 GMT

At least we know it's still configurable! :-P

RE: SQL Audit

CavyPrincess — Fri, 16 Jul 2010 05:58:12 GMT

I had to research it the first time. At least this time, I knew the answer. My biggest excitement - actually remembering something "all the way" back to July 9 :)Cindy

RE: SQL Audit

wagabunda — Fri, 16 Jul 2010 05:37:06 GMT

one more point - easy one :)

RE: SQL Audit

webrunner — Fri, 16 Jul 2010 04:06:54 GMT

Yes, the question is a repeat of a recent QOTD. I'd understand if it were wiped out and my hard-earned point revoked. :-P- webrunner

RE: SQL Audit

prashant.bhatt — Fri, 16 Jul 2010 03:35:28 GMT

B O N U S P O I N T...

RE: SQL Audit

paul s-306273 — Fri, 16 Jul 2010 02:23:42 GMT

At least the question was error free and had no tricks!

RE: SQL Audit

free_mascot — Fri, 16 Jul 2010 01:22:14 GMT

Same question as QOD 9th July. Once more secure point ;)

RE: SQL Audit

Shanalise — Fri, 16 Jul 2010 01:06:04 GMT

May be the people are getting it wrong did not answer it on 9 July 2010

RE: SQL Audit

Carlo Romagnano — Fri, 16 Jul 2010 01:03:21 GMT

It's the same, but many people get it wrong again.:-D:-D:-D

RE: SQL Audit

mohammadk-1135894 — Thu, 15 Jul 2010 23:54:41 GMT

This is the same Question which was asked earlier also on 9 July 2010 :-P

RE: SQL Audit

SQLRNNR — Thu, 15 Jul 2010 23:04:15 GMT

Maybe this question has come about again due to a lack of contributions...

RE: SQL Audit

Shanalise — Thu, 15 Jul 2010 22:58:24 GMT

maybe it is for a bonus point

RE: SQL Audit

norie — Thu, 15 Jul 2010 22:52:26 GMT

yes this question repeated

RE: SQL Audit

Henrico Bekker — Thu, 15 Jul 2010 22:27:27 GMT

This is the same QOTD from 9 July 2010 :-D

SQL Audit

Steve Jones - SSC Editor — Thu, 15 Jul 2010 20:36:06 GMT

Comments posted to this topic are about the item [B]SQL Audit[/B]