History System Access - Sql Server 2014

Question

To save my access / logging history table I should use a stored procedure or a trigger when my user is logged in ?

Priyaranjan K S · Answer

Hi Daniel  You can implement an Audit trigger to track the user logging details . These links will help you implementing it . http://solutioncenter.apexsql.com/auditing-triggers-in-sql-server-databases/ https://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/ Thanks Priyan If you found this useful Please Accept this as Answer