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

Database level auditing in 2008r2 standard edition Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 7:14 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, March 23, 2014 7:35 PM
Points: 129, Visits: 265
Hi
I need to create an audit for a single user at the database level but I am running 2008r2 and 2005 standard edition. Is there a way to do that? Any suggestions would be appreciated.
Post #1524121
Posted Wednesday, December 18, 2013 8:51 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:02 AM
Points: 177, Visits: 789
With Standard Edition you are limited with your choices but, you could run a server-side trace for just their ntusername. That would span across all databases or just a subset - Just be careful as the the amount of data that you return as it could get large depending on the amount of work that individual did in the system.

SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Post #1524186
Posted Wednesday, December 18, 2013 10:42 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, March 23, 2014 7:35 PM
Points: 129, Visits: 265
I am finding that my options are limited in standard edition.

Thanks
Post #1524240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse