Hi, I believe that audit specifications cannot be used in the standard version of SQL 2008 and 2008 R2 ? If this is the case, how can I create an audit trail on a table or view which records info
such as Active Directory account name (of query executor), date and time of query, query details (ie. select statement), etc etc for each select query executed on the table or view.
Any help much appreciated, my client cannot upgrade to enterprise (and therefore
use audit specifications) to to cost limitations.
View Complete Post