TR_UserPersonalPages_CASCDE_DEL_1

                  CREATE  TRIGGER [dbo].[TR_UserPersonalPages_CASCDE_DEL_1] ON [dbo].[UserPersonalPages]
    INSTEAD OF DELETE
    AS
    SET NOCOUNT ON
    DECLARE @Count integer
    Select @Count=Count(*) from deleted
    if @Count>0
    BEGIN

        DELETE FROM PersonalPageData WHERE UserPersonalPageID IN (SELECT ID FROM deleted)

        DELETE FROM Comments WHERE UserPersonalPageID IN (SELECT ID FROM deleted)

        -- reissue the delete
        DELETE FROM UserPersonalPages
            WHERE ID IN 
            (SELECT ID FROM deleted)

    END