Make a copy of records within a table each time it is updated or a new record is created. This is very basic stuff. I'll be working on an update to handle primary keys and such.
code: Can't Copy and Paste this? Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
--**************************************
--
-- Name: Log Record Changes
-- Description:Make a copy of records wi
-- thin a table each time it is updated or
-- a new record is created. This is very ba
-- sic stuff. I'll be working on an update
-- to handle primary keys and such.
-- By: Lewis Moten
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/vb/scripts/Sh
-- owCode.asp?txtCodeId=470&lngWId;=5--for details.--**************************************
--
/*
-- Basics for setting up a log file.
-- Replace the [MyTable] with the table
-- you wish to log
*/
-- Copy Schema
SELECT * INTO [dbo].[Log_MyTable] FROM [MyTable]
WHERE 1=2
GO
-- Create trigger
CREATE TRIGGER dbo.[MyTable_log] ON dbo.[MyTable]
AFTER INSERT, UPDATE AS
INSERT INTO Log_MyTable SELECT * FROM INSERTED
GO
