Block .Text Blog Spam
I am very tired of the comments of the style "Texas Online Casino" and as the version of .Text that I use doesn't implement any mechanism to avoid this type of comments I modify this trigger a little to avoid this situacion.
CREATE TRIGGER blog_Content_TriggerON blog_Content AFTER INSERT, UPDATE, Delete
AS
DECLARE @BlogID INTDECLARE @ID INTDECLARE @PostType INTDECLARE @ParentID INT
SELECT @BlogID = BlogID, @ID = ID FROM INSERTED
IF (@BlogID IS NULL)BEGIN SELECT @BlogID = BlogID, @ID = ID FROM DELETED END
SELECT @ParentID = ParentID, @PostType = PostTypeFROM blog_ContentWHERE [ID] = @ID--Add more "spam words" hereAND ( [Text] LIKE '%poker%' OR [Text] LIKE '%pharmacy%'...
GUI's Gallery
Nice site, it brought me many good memories...