USP_EVENT_BASICCMS_DELETE

                    CREATE procedure dbo.USP_EVENT_BASICCMS_DELETE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as begin
                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        declare @CURRENTDATE datetime = getdate()

                        declare @EVENTTABLECATALOGID uniqueidentifier = '3EF5D061-5692-40F3-B8AD-1367A8C6FAD5'

                        declare @WEBFORMSPAGES table (
                            ID uniqueidentifier,
                            SITEPAGESID integer
                        )
                        insert into @WEBFORMSPAGES
                        select 
                            ID, 
                            SITEPAGESID
                        from dbo.MICROSITEPAGE 
                        where 
                            TABLECATALOGID = @EVENTTABLECATALOGID and
                            OBJECTID = @ID 

                        update dbo.VanityURL 
                        set 
                            RealmID=0, 
                            PageID=NULL, 
                            TargetURL = (select value from dbo.MICROSITESETTING where MICROSITESETTING = 1),--Home Page

                            DATECHANGED = GetDate()
                        where exists (select 1 from @WEBFORMSPAGES [WFP] where VanityURL.PageID = [WFP].[SITEPAGESID])

                        update dbo.MICROSITEPAGE 
                        set 
                            EXCLUDED = 1,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where exists (select 1 from @WEBFORMSPAGES [WFP] where MICROSITEPAGE .ID = [WFP].[ID])

                        return 0;
                    end