Basics of C2 Auditing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Dinesh Asanka » Basics of C2 Auditing

Basics of C2 Auditing

Rate Topic

Display Mode

Topic Options

Author

Message

Dinesh Asanka

Posted Friday, October 08, 2004 3:32 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912, Visits: 198

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dasanka/basic

My Blog: http://dineshasanka.spaces.live.com/

Post #140885

venkataramanis

Posted Saturday, December 29, 2007 2:53 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 04, 2010 8:20 AM
Points: 23, Visits: 96

In c2 audit mode option the trace file size will go up to 200 mb. Is it a configurable one. i.e whether we can configure it to 10 mb . because our db size is 20 gb.

can be done or not?

Post #437316

Jeff Moden

Posted Saturday, December 29, 2007 9:20 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923, Visits: 26,811

It appears that this article was written quite some time ago... but, boy, is it sweet. I haven't tried it yet but Dinesh sure did make it easy.

You can just bet I'm going to try it...

Thanks, Dinesh! 5 stars!

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #437338

bchi49

Posted Wednesday, March 19, 2008 8:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 22, 2008 6:13 PM
Points: 1, Visits: 7

how can the C2 audit trace output files be redirected to another location (drives and folders) other than the default instance location?

Thanks,
Benjamin

Post #471590

venkataramanis

Posted Wednesday, March 19, 2008 10:55 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 04, 2010 8:20 AM
Points: 23, Visits: 96

I read your documentation clearly. I dont find any configuration to limit the size of the audit trace from 200 mb to 20mb or anything . And also there is no way in creating the file to different location other than mssql\data folder.

I just need to know whether it can be enabled by any option like writing SP or triggers.

Regards,

Venkat

Post #472059

« Prev Topic | Next Topic »

Permissions