Hi,
I would like to know the possible solutions for this scenario below regarding database auditing
Our requirement is to audit SQL Server databases when
- Update
- Insert
- Select (View)
- Delete rows from table
- Rename
- execute
statements occur on the database with the following information as the output
- Username,database_name
- Date and time (dd-mmm-yyyy) (hh:mm:ss)
- The action carried out
- how long the process took to complete
These databases are very huge(1.5 tb)
I am currently exploring database auditing feature at the moment that fits all the needs except for
'how long the process took to complete'. any suggestions?
Any other suggestions(apart from DB Auditing) on how to achieve this?
Thanks
Bhnau