Home Forums SQL Server 2008 Security (SS2K8) Tracking User access to a database on SQL 2008R2 Standard RE: Tracking User access to a database on SQL 2008R2 Standard

  • I don't have much to add to Andreas's response, but I note that your spec is somewhat vague. It would help to know more about this database, and why it has to be audited.

    If all access is by stored procedures, you can put the auditing since the stored procedures. Furthe more write access can be audited by triggers. But direct SELECT statements can only be audited by trace or SQL Server Audit. And the latter, as Andreas pointed out, is only in Enterprise Edition.

    I also like to remark that when you posted the "system details", you posted the details about Managerment Studio on your workstation, which says little about the server. To that end, you should post the output of "SELECT @@eversion".

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]