Login log.........

• b_boy

  SSCertifiable

  Points: 5145

  More actions

  March 21, 2008 at 2:58 am

  #122717

  Hello

  Does anyone know how I can view or implement the status of user login in terms of when and what time the user actually logged into the database?

• Johan Bijnens

  SSC Guru

  Points: 135445

  More actions

  March 21, 2008 at 5:28 am

  #792387

  If you are on SP2, you can use login triggers.

  They only fire at login time.

  If a user switches db in his current connection, you may not see it.

  Check bol

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  March 21, 2008 at 7:25 am

  #792424

  SQL can track successful and unsuccessful logins by default ... you have to enable the option, which requires a SQL restart:

  USE [master]

  GO

  EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, 3

  GO

  This can be viewed by right clicking your database server, properties, security.