Post reply

SQL 2008 Audit Question

  • March 14, 2011 at 9:24 am

    #236167

    Hello all,

    I have a question regarding SQL 2008 Audit functionality. I would like to audit activities in one of my databases that originate from other than the databases associated database.

    For example, using the Activity Monitor I can identify what application generated the connection to my database.

    I would like to monitor connections and their activity that were generated from outside my application such as a query executed from Management Studio.

    We are a windows shop using trusted connections, therefore the user context of (INTRANET\xxxxxxx) is what SQL see regardless of where the connection originated from.

    Is there a way using SQL 2008 Audit, to identify and audit only specific connections based on their origin?

    Thanks in advance,

    Shawn

  • March 14, 2011 at 9:35 am

    #1298404

    I am no expert (never used SQL audit) but you could do this with profiler.

    Dan

  • March 15, 2011 at 6:56 am

    #1298811

    danielfountain (3/14/2011)

    I am no expert (never used SQL audit) but you could do this with profiler.

    Dan

    Dan, Thanks for the reply. I was hoping to keep an audit solution under one roof so to speak.. But if I can't, I will most likely leverage SQL Profiler. It just seams, ya outta be able to audit which application sent the request.

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

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