Nice post on using CDC to create Audit Trails

SQL Server Mentalist

 

Hi Friends,

If you do not have prior knowledge for CDC Concept of SQL Server please read the following CDC blog post

Now lets understand implementation of Audit Trailing with CDC Concept :

CDC will facilitate user to enable/disable the Audit Trailing on the Database Level. There will not be direct visible impact on the UI by CDC functionality.

image

Following is High level overview for CDC processing

image

CDC Audit Trailing requirements

  • To track any modification performed on the database and to track all the changes in Database at every level, Audit Trailing needs to be implemented.
  • As per Database requirement Auditing is most important aspect to track change details and…

View original post 662 more words

Advertisements

About Ed Jones

Ed is a .NET and Integration architect for Avanade in the Twin Cities. Contact Ed

One response to “”

  1. Vishal Pawar says :

    Thanks Ed Jones for re blogging !!

What do you think?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: