Post reply

CDC and username capture

  • August 13, 2015 at 3:18 pm

    #306807

    I am implementing CDC to capture some specific column value change in a table. With the value I need to capture who changed the value as well. Unfortunately it looks like CDC does not capture the user details. How can I do this?

    Any pointers would be greatly appreciated.

    Thanks

  • August 14, 2015 at 5:04 pm

    #1820253

    Guras (8/13/2015)

    I am implementing CDC to capture some specific column value change in a table. With the value I need to capture who changed the value as well. Unfortunately it looks like CDC does not capture the user details. How can I do this?

    Any pointers would be greatly appreciated.

    Thanks

    Not available within the capacity of CDC. You may have to resort to Trigger or SQL Server Audit.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply