Post reply

SQL Server 2005 - Monitoring Specific Accounts

  • February 8, 2011 at 5:45 pm

    #388811

    Hi and thanks in advance to all who respond. Question: can SQL Server 2005 monitor specific user accounts natively?

    Example: I want to set up SQL Server (without the aid of 3rd party software) to monitor and log the activity of the domain account 'SQL DBA GROUP'?

  • February 28, 2011 at 1:26 pm

    #1292557

    Setting up a server-side trace is the first thing that comes to mind. Trace will allow you to capture the activities for a specific set of logins at a very granular level including when they login to the instance and what ad hoc sql batches and stored proc executions they submit.

    That said, I don't know if trace can be set to capture activity by filtering on an Active Directory (AD) group. I think the filter only applies to SQL Logins and specific AD Accounts meaning if 'SQL DBA Group' is an AD group and new AD accounts were added to that group you would need to update your trace filters.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 28, 2011 at 6:41 pm

    #1292677

    Thanks opc.three. Much appreciated.

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

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