Trigger to keep track of users

• Ghanta Bro

  Ten Centuries

  Points: 1079

  More actions

  July 10, 2006 at 10:09 am

  #113535

  Hey Guys,

  I am SQL Developer and I do not have any experience in the DBA side. Can anyone help me write a trigger that can log users. Thanks in advance.

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  July 11, 2006 at 12:48 am

  #648367

  Here is one way:

  http://www.sqlservercentral.com/columnists/spustovit/easyauditingasharedaccount.asp

  You should also check out Steve's series:

  http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart1.asp

  http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart2.asp

  http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart3.asp

  http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart4selectiveauditing.asp

  Andy

• Ghanta Bro

  Ten Centuries

  Points: 1079

  More actions

  July 13, 2006 at 8:39 am

  #648990

  Thanks a lot Andy.