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.