SQL 2000 Last Login Date..? Exists?

• Topher

  SSCommitted

  Points: 1763

  More actions

  December 11, 2007 at 5:19 pm

  #377454

  Silly Q. Does mssql have a last login function in 2000? I know many have applied patches to their sql 2000 for reason similar including seperation of duties..

  -Chris

• Steve Jones - SSC Editor

  SSC Guru

  Points: 735942

  More actions

  December 11, 2007 at 6:11 pm

  #759227

  You can build a DDL trigger for the login event and log the users that connect.