How to Use the SQL Server 2008 Audit Object

In this video Brian covers how to use the new SQL Server 2008 audit objects security feature. The audit objects takes events that you're looking to monitor and records them to a specific location.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

TechyGirl on 8/4/2009

cool! I had no idea this even existed.

sreekanth on 8/13/2009

Simply Awesome Stuff.......Great Work by JmupstartTV

Leo Njampa on 8/17/2009

Great demo!

6747E1D15B on 8/24/2009

Useful to be reminded this capabiity exists. Thanks.

Sinimol on 8/25/2009

Good!

C G on 8/25/2009

didn't explain the difference on where the audit specification would need to be created on server vs database.

F02BAB3EBE on 8/25/2009

Great job, very useful jumpstart into 2008 auditting

NehalRana on 8/25/2009

how about audit tables entry

5DEBD9235C on 8/25/2009

good examples

5DEBD9235C on 8/25/2009

good video; but might be helpful to include a quick How-To vid for locking down rights to 'security', or at least applying rights to those who do nothing more than security auditing. in a segregated environment like bank of america for example this is something which is used all the time.

luther smith on 8/25/2009

Very clear. Presenter should speak a little slower.

Ahmad ALQattan on 9/9/2009

good

Ahmad ALQattan on 9/9/2009

good

Ahmad ALQattan on 9/16/2009

err

eric cantona on 9/21/2009

Clear and concise

bacchelor on 10/21/2009

excellent

Bala on 12/14/2009

it is really.i am expecting that the sqlshare should provide more video like this. Thank you very much.

R on 3/4/2010

thankz

R on 3/4/2010

thankz

Mark Hions on 7/16/2010

A screen zooming tool would help tremendously

pavan on 8/20/2010

excellent and great article ,thks

Matt on 8/20/2010

Nice video, very clear.

punjwani on 8/20/2010

gr8

947C03EA21 on 8/20/2010

I can see an immediate application for this technique. Thanks

Michael on 8/20/2010

Very good information presented. Might want to slow down just a little bit.

James Lawrence on 8/20/2010

Brian, is there any way to capture an application name in server audit? For example, if I have a Windows app called 'PayrollMaint' and a I delete a payroll record using this app, is there anyway to put the value 'PayrollMaint' in the audit log?

Ed Svastits on 8/20/2010

Straightforward.

Syed Hassan on 8/20/2010

Great video. Thank you!

Don Weigend on 8/20/2010

Very nice demo!

Alin Winters on 8/21/2010

Great video. Good instructions.

Cosmin Tornea on 8/25/2010

wow

Cosmin Tornea on 8/25/2010

wow

Charlie Bruno on 8/25/2010

Excellent presentation, well planned and demostrated. I learned something new. Great work guys.

jamie on 9/21/2010

What happens if you restore an audited database to another server? Do you have to disable the audit like you disable triggers set at the database level?

Nimesh Parikh on 12/5/2010

Good to know this

Ameena on 4/7/2011

As always very useful demo. Great job. Keep it up.