?
Solved

generic Database audit trail

Posted on 2009-04-17
3
Medium Priority
?
524 Views
Last Modified: 2012-05-06
Hi Expert,

How to setup / configure generic database audit trail. and also to view the audit the data.

Thanks & Regards
Ram
0
Comment
Question by:ramadadi
  • 2
3 Comments
 
LVL 7

Expert Comment

by:luani
ID: 24165844
Hi,
check the SQLAudit tool at :
www.apexsql.com
0
 
LVL 25

Expert Comment

by:reb73
ID: 24165853
If you want access and user activity, have a look at the link below on configuring SQL Server's built-in traces..

If you need actual data or object maintenance audited, use a custom audit table and/or DDL triggers to capture changes at a database or server level..
0
 
LVL 25

Accepted Solution

by:
reb73 earned 2000 total points
ID: 24165856
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question