Database

CREATE TABLE enumEquipment([Label] VARCHAR(10) PRIMARY KEY)
 INSERT INTO enumEquipment (Label) VALUES ('Tank'), ('Suit'), ('Fins'), ('Mask'), ('Snorkel');

CREATE TABLE someTableUsingTheEnum
(
  Id INT IDENTITY(1,1) PRIMARY KEY,
  EnumValue VARCHAR(10) REFERENCES enumEquipment (Label)
)
 INSERT INTO someTableUsingTheEnum (EnumValue) VALUES ('Tank') -- works
 INSERT INTO someTableUsingTheEnum (EnumValue) VALUES ('Micky') -- fails
 
 SELECT * FROM someTableUsingTheEnum -- shows 1 record, with 'Tank'
 
DROP TABLE someTableUsingTheEnum
DROP TABLE enumEquipment

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

ALTER TABLE EQIPMENT
ADD CONSTRAINT EQUIPMENTTYPE_CHK CHECK (DIVEKIT IN ('Tank', 'Suit', 'Fins', 'Mask', 'Snorkel')

Jörgen Andersson wrote:

the OP only wanted to limit the items in a column

SELECT  [Guid] ,
        UserGuid ,
        ReferenceGuid ,
        ReferenceID ,
        [Event] ,
        Comments ,
        [Time] ,
        IPAddress
FROM EventLogs AS elog
INNER JOIN (
    SELECT [Guid]
    FROM EventLogs elog1
    INNER JOIN (
        SELECT [Event], MAX([Time]) AS MTime
        FROM EventLogs
        GROUP BY [Event] ) AS t ON elog1.[Event] = t.[Event] AND elog1.[Time] = t.MTime
) AS elog3 ON elog.[Guid] = elog3.[Guid]

SELECT  [Guid] ,
        UserGuid ,
        ReferenceGuid ,
        ReferenceID ,
        [Event] ,
        Comments ,
        [Time] ,
        IPAddress
FROM     EventLogs
WHERE   ( [Guid] = ( SELECT TOP ( 1 )
                            [Guid]
                   FROM     EventLogs AS elog
                   WHERE    ( ReferenceGuid = EventLogs.ReferenceGuid AND Event=EventLogs.Event)
                   ORDER BY Time DESC
                 ) )

with cte as (
    SELECT  [Guid] ,
            UserGuid ,
            ReferenceGuid ,
            ReferenceID ,
            [Event] ,
            Comments ,
            [Time] ,
            IPAddress,
            rn = ROW_NUMBER() OVER (Partition By Event Order By Time Desc)
    FROM     EventLogs
)
select * from cte where rn = 1