Post reply

Audit changes made by MSSMS

  • January 31, 2018 at 9:19 am

    #403041

    Hi all,
    I´m implementing an audit requirement in our SQL server. The front end is an ERP, so all the logins to the DB are the same login.
    We need to audit any change done by the Management Studio not by the "natural" procedure done by the ERP.

    I have tested some parameters in the out of  the box auditing capabilites of SQL 2008, but I "only" can catch all the writes-updates from all sessions.

    Any idea on how to catch modifications done by Micrososft SQL Server Management Studio? or add hostname/ip address of the client who did the change?

    Thank you in advance.

  • January 31, 2018 at 10:33 am

    #1978065

    mig28mx - Wednesday, January 31, 2018 9:19 AM

    Hi all,
    I´m implementing an audit requirement in our SQL server. The front end is an ERP, so all the logins to the DB are the same login.
    We need to audit any change done by the Management Studio not by the "natural" procedure done by the ERP.

    I have tested some parameters in the out of  the box auditing capabilites of SQL 2008, but I "only" can catch all the writes-updates from all sessions.

    Any idea on how to catch modifications done by Micrososft SQL Server Management Studio? or add hostname/ip address of the client who did the change?

    Thank you in advance.

    Hostname and App name are part of the data captured for each session. I'm not sure what you are using for auditing but maybe you could filter by that.
    Extended events if available or Profiler will be able to filter by application.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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