SQL Server - Sqlserver Audit
Asked By k syam on 05-Dec-12 03:31 AM
Hi all,
I have to know one thing
i.e What is the meaning of Sql server Audit and what is the use in Real time is there any good links for knowing from Basic ,in what type of application it is used like bank apps or e commerce sites...
Robbe Morris replied to k syam on 05-Dec-12 01:28 PM
It is used to audit access and modifications to tables. Yes, banks would be likely. Law enforcement would also be another category of application types that might want to keep track of this sort of thing.
Do not use it willy nilly though. It has a pretty negative impact on performance.