CREATE TABLE SourceData
	(SomeData VARCHAR(20))

INSERT INTO SourceData VALUES ('abc')
INSERT INTO SourceData VALUES ('def')
INSERT INTO SourceData VALUES ('ghi')
INSERT INTO SourceData VALUES ('jkl')

CREATE TABLE TargetData
	(tdID INT Identity(1,1) NOT NULL,
	SomeData VARCHAR(20))

CREATE TABLE DataLog
	(tdID INT, DateOfEntry DATETIME DEFAULT (GETDATE()))

CREATE TRIGGER tr_i_TargetData
ON TargetData
FOR INSERT
AS
	INSERT INTO DataLog (tdID)
	SELECT tdID FROM Inserted
GO

INSERT INTO TargetData (SomeDAta) VALUES ('TestEntry')

SELECT * FROM DataLog