Post reply

Database level auditing in 2008r2 standard edition

  • December 18, 2013 at 7:14 am

    #301480

    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.

  • December 18, 2013 at 8:52 am

    #1674473

    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

  • December 18, 2013 at 10:42 am

    #1674518

    I am finding that my options are limited in standard edition.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply