Post reply

can I map an LSN to a username or hostname?

  • September 24, 2008 at 9:01 am

    #198710

    I am exploring CDC and I found a way to map he LSN to a datetime using sys.fn_cdc_map_lsn_to_time ( lsn_value ), but I cannot seem to find a way to map to a user and/or host. I find this odd since, from a management perspective, the most common question I get after I can explain "WHAT happened," is "WHO did it?"

  • February 4, 2010 at 12:02 am

    #1113492

    If you are going to use the LSN to get to the UID (given your application does not impersonate and you don't have roles instead of users etc.) you may get to the user with a lot of gymnastics. Have a look at the document SQL Server Forensics (by Emergis) or to explore the transaction log.

  • February 4, 2010 at 12:09 am

    #1113496

    Drikus Roux (2/4/2010)

    If you are going to use the LSN to get to the UID (given your application does not impersonate and you don't have roles instead of users etc.) you may get to the user with a lot of gymnastics. Have a look at the document SQL Server Forensics (by Emergis) or to explore the transaction log.

    Most excellent resource. Thanks for posting it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 4, 2010 at 12:24 am

    #1113505

    Thanks Drikus for this gr8 doc.

  • November 14, 2012 at 2:51 am

    #1558812

    Hi,

    CDC who username problem?

    Help..

    SQL Server Consultant
    yusufkahveci@sqlturkiye.com
    www.sqlturkiye.com

  • November 14, 2012 at 5:59 am

    #1558885

    2 year old thread. Please post new questions in a new thread. Thank you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

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