Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Using the Service Audit Object in SQL Server 2008 Expand / Collapse
Author
Message
Posted Thursday, December 18, 2008 1:23 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
Comments posted to this topic are about the item Using the Service Audit Object in SQL Server 2008

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #621839
Posted Thursday, December 18, 2008 9:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, June 21, 2014 6:47 AM
Points: 41, Visits: 70
You mention that SQL Server Audit object is available in any version of SQL other than Express, however, Audit is only available in 2008 Enterprise. Is there a water down version of auditing available in versions other than 2008. What alternatives are available to perform similar auditing when not using Enterprise edition?
Post #622254
Posted Thursday, December 18, 2008 11:38 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
What I said in the article was that just about every edition above Express *could* use it. But Microsoft chose to only put it in Enterprise Edition. For those of us who started using Standard Edition for 2-node HA clusters, this hurts. Standard Edition is economical and meets our needs. Enterprise Edition is pricey. But if we want to use the Audit object, we've got no choice but to use Enterprise.

As far as alternatives, there's nothing similar to it in the other versions.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #622370
Posted Sunday, December 21, 2008 1:49 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,439, Visits: 1,400
Great article...


Post #623547
Posted Monday, May 11, 2009 12:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 11, 2009 12:22 PM
Points: 1, Visits: 0
What are recommended options for auditing tools and/or utilities for people that are using the MS-SQL standard and web editions?

We have a public facing web site where our biggest auditing need (in addition to what we can see in the regular OS event logs) is to track DBA actions.
Post #714410
Posted Saturday, August 8, 2009 12:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 11:51 PM
Points: 14, Visits: 170
Hi Brian,

Very nice article. I was able to configure the auditing but I am not getting the parameter values in the audit.

Ex. If some executed a query as follows:
select name, age from dbo.employees where empno = 100.

This above query is being audited as follows:
select name, age from dbo.employees where empno = @1.

How can I get the value of @1?

Regards,
Atiq Rahman
Post #767426
Posted Saturday, August 8, 2009 12:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 11:51 PM
Points: 14, Visits: 170
Hi Brian,

Very nice article. I was able to configure the auditing but I am not getting the parameter values in the audit.

Ex. If some executed a query as follows:
select name, age from dbo.employees where empno = 100.

This above query is being audited as follows:
select name, age from dbo.employees where empno = @1.

How can I get the value of @1?

Regards,
Atiq Rahman
Post #767427
Posted Thursday, August 20, 2009 8:41 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
This may be one of the weaknesses in the Audit Object. I need to play around a bit more to see if you can capture the parameter, but at first glance, I'm not sure you can.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #774740
Posted Wednesday, January 6, 2010 11:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 6, 2010 11:27 PM
Points: 2, Visits: 1
Hi,

Nice article....You have done good job....Thank you.....

---------------------------------------
Auditing Tools
Post #843332
Posted Friday, April 2, 2010 12:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:06 AM
Points: 904, Visits: 1,996
Brian, thanks much for this article! It was exactly what I needed to get a test system going to explore what the audit offered. I had been fiddling with it to no avail, read your article, and had it running shortly thereafter.

I was a little disappointed that the file export was to log format, I was hoping I could get it out as a CSV. There is the export function, I think I'll be looking in to automating dumping the contents to a text file.

I think it's basically a good thing, but it still has some growth.


-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Post #895467
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse