SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Items
(
    [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [Key] [varchar](50) NOT NULL,
    [Value] [varchar](255) NOT NULL
);
CREATE TABLE RecordDeletionTimes
(
    ID BIGINT IDENTITY NOT NULL,
    [Schema] NVARCHAR(128) NOT NULL,
    [Table] NVARCHAR(256) NOT NULL,
    [Record ID] INT NOT NULL,
    [Date-Time] DATETIME2 NOT NULL,
    [Record Information] NVARCHAR(1024) NULL,
    CONSTRAINT [Record Deleted Times Primary Key] PRIMARY KEY CLUSTERED
    (
        ID ASC
    ),
    CONSTRAINT [Record Deleted Modified Times Unique Key] UNIQUE NONCLUSTERED
    (
        [Schema] ASC,
        [Table] ASC,
        [Record ID] ASC,
        [Date-Time] ASC
    )
);
CREATE TRIGGER [Items Deleted]
    ON Items
FOR DELETE
AS
    INSERT INTO RecordDeletionTimes
    SELECT
        'dbo',
        'Items',
        deleted.ID,
        GETUTCDATE(),
        CONCAT
        (
            'Key: ''',
            [Key],
            ''' Value: ''',
            Value,
            ''''
        )
    FROM deleted ;
insert into items select 'apple','green';
1 rows affected

delete from items;
2 rows affected

select * from RecordDeletionTimes;


ID
Schema
Table
Record ID
Date-Time
Record Information


1
dbo
Items
1
2022-02-02 16:25:28.0366667
Key: 'apple' Value: 'green'