TR_VANITYURL_UPDATE

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