Results 1 to 3 of 3

Thread: SQL 2008 CDC (capturing Loginname /username)

  1. #1
    Join Date
    Apr 2003
    Posts
    6

    Arrow SQL 2008 CDC (capturing Loginname /username)

    Hi,
    I was wondering if there is any way to capture login/username of the account that has commited the change. Obvously with CDC I can keep a track of all the changes and the time that they occured but there are no indication to the loginname/username in the captured information.
    Regards,
    K

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Tried schema changes history report?

  3. #3
    Join Date
    Apr 2003
    Posts
    6
    Thanks
    But I'm interested in data changes not schema

    I simply use CDC to capture data changes
    But can't find a way to map that to a login or username

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •