Capturing time logged in

• mcopa

  Say Hey Kid

  Points: 699

  More actions

  May 9, 2013 at 2:30 pm

  #273724

  I have been tasked with replicating functionality in place on our Oracle servers that captures the amount of time a user was logged in. The long-gone Oracle admin created a trigger that fired upon logout and recorded such things as how long the user was logged in. I have never done anything with triggers in SQL so am not even sure that a trigger is the best option. The purpose of this whole exercise is to be able to charge for SQL usage based on how long the user was logged in. Any ideas?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  May 9, 2013 at 2:40 pm

  #1613974

  You could enable login auditing or use a DDL trigger

  http://msdn.microsoft.com/en-us/library/ms190989%28v=SQL.105%29.aspx

  http://msdn.microsoft.com/en-us/library/ms175850.aspx