CaptureLogs

Question

CaptureLogs

bhakti-sonu

Mr or Mrs. 500

Points: 556
More actions
June 27, 2008 at 1:14 am

#208996

i want to save a log as a fields:-
LogID=PKID
LoginID=EmployeeID
LogInDateTime
EntityAccessed=Name
EntityChanged=Name
EntityAdded=Name
EntityDeleted=Name
LogOffDateTime
for my windows application
how to do this?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

What exactly is your application doing, and what is it written in? This kind of information is best implemented not in CLR but with standard DDL Triggers. The only tricky one is the LogOut. There is no DDL Trigger for Audit Logout. However, Jim McLeod created a method using Service Broker that he posted on his blog:

http://www.jimmcleod.net/blog/index.php/2008/05/28/auditing-user-log-out-events/