May 9, 2013 at 2:30 pm
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?
May 9, 2013 at 2:40 pm
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
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply