SQL Server Audit Issue

  • I have setup a SQL Server 2008 audit easily enough, to track updates against a specific table. however, the audit output does not contain hostname. If an update is done under the context of a common/generic account (like the one used by an application), showing me the update but not where it came from is fairly useless. Can I get this info from within SQL Server Audit or am I going to need to resort to my own triggers?

  • I don;t really have an answer but I am also curious about your question. I'm just getting auditing set up myself.

    My question I think will be about how to view/import (via SSIS) the audit files as they are generated.

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

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