Logging entries made in SQL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Logging entries made in SQL

Hi there, If i’m posting this in the wrong group please redirect me. I’m working on a database (SQL 2005) in combination with and Access front_end. I would like to log any records being added or edited in my SQL backend. How would I go about that? Thanks in advance Maurice
Welcome to the forum!
You can take help of triggers in this case,http://www.sql-server-performance.com/kk_log_file_trigger.asp link. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Btw, you hardly would want to track each and every single action performed against each single table. I would go with the most sensitive ones and leave lookup tables or parameter tables out of this. —
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com
Webmaster:http://www.insidesql.de
Wow that’s what I call a serious quick reply. Thanks Satya and Frank.
Frank you are absolutely right. I’m not going to monitor all but just the sensitive ones.
Satya i’m going to follow up the link you suggested. Maurice
[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />] You would get a normal reply to check for triggers from the question asked, but as it is specific to need I have suggested relevant material and follow as Frank suggsted.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
– you could also create a snapshot database if you don’t want the overhead of maintaining the triggers.
– but also this has its space and performance related downsides.
]]>