capture application login in sql server trigger

• ALI-408105

  Say Hey Kid

  Points: 709

  More actions

  May 11, 2010 at 12:16 pm

  #220911

  Is it possible to capture application user in delete trigger?

  We are trying to use sql server delete trigger to audit physical deletes issued from java application. My problem is how can I capture applicaiton deleted by user in sql trigger???

• Cory E.

  SSCertifiable

  Points: 7076

  More actions

  May 11, 2010 at 12:21 pm

  #1165750

  Just a guess, what about something like one of these?

  select suser_sname(), suser_name()

  -- Cory