• :w00t: fascinating concept.

    Which versions of SQL is this intended for? I am getting error from SQL Query Analyzer 2000 when try to execute the trigger section on a db running in SQL Server 2005 :

    Server: Msg 207, Level 16, State 1, Procedure trgInsertLogEntry, Line 21

    Invalid column name 'tags'.

    Points to line:

    SET @tags = (SELECT tags FROM INSERTED)

    Where did table "INSERTED" get made?