Add application to SQL CDC records

38 Views Asked by At

I want to implement CDC on a database but capture the application info from the process that made the change. Is there some way to get that information in the CDC data? I quite often get asked by clients of what changes were made to their data and who did that change. In the application information our software includes the user name of the person that was logged in at the time so between what can be captured with CDC and that application info I can give them exactly what they want.

0

There are 0 best solutions below