System table Question

• Kevin-130791

  SSChasing Mays

  Points: 622

  More actions

  November 6, 2008 at 9:58 pm

  #131975

  Which system table would have information (timestamp) when a user has log into the database, I want to see who has been in a certain database in the last six months.:doze:

• Elisabeth Rédei

  Hall of Fame

  Points: 3873

  More actions

  November 7, 2008 at 7:16 am

  #895522

  Hi,

  That kind of auditing could be quite resource consuming so it isn't something that happens by itself. You would have to setup some auditing yourself.

  /Elisabeth

  elisabeth@sqlserverland.com
  MCITP | MCT
  http://sqlblog.com/blogs/elisabeth_redei/
  http://linkedin.com/in/elisabethredei