Post reply

pleas sympathy me

  • November 1, 2010 at 1:48 am

    #225735

    hi all.

    we have one web application and one database that are on two diffrent server.now we want to store changed data that occure

    with insert.update&ddelete,we can store this with cdc tables easily,but we need to store client's IP and computer name of

    client which do this changes.what way suggest?what way we do?

  • November 1, 2010 at 3:13 am

    #1244730

    Sounds like a trigger may be necessary.

    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

  • November 1, 2010 at 4:49 am

    #1244760

    Hi

    You are inserting/deleting/Updating data tro .Net then you can try with .Net itself,in.Net there is Possibility of doing it.You can code which will capture Client's IP address but not sure computer name.

    Thanks

    Parthi

    Thanks
    Parthi

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

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