TR_VANITYURL_INSERT

    CREATE TRIGGER [dbo].[TR_VANITYURL_INSERT] ON [dbo].[VANITYURL] AFTER INSERT NOT FOR REPLICATION
    AS
    update dbo.VANITYURL set DATECHANGED = GetDate(), DATEADDED = GetDate() from dbo.VANITYURL inner join INSERTED on VANITYURL.ID = INSERTED.ID;