USP_BATCHASSIGNEDALERT_SEND

            CREATE procedure dbo.USP_BATCHASSIGNEDALERT_SEND (
                @PREVIOUSOWNERID uniqueidentifier,
                @BATCHID uniqueidentifier
            ) as begin

                declare @OWNERID uniqueidentifier;
                select @OWNERID = BATCH.APPUSERID from dbo.BATCH where BATCH.ID = @BATCHID;

                if (@PREVIOUSOWNERID is null) or (@OWNERID <> @PREVIOUSOWNERID)
                    exec dbo.USP_ALERTTYPE_SENDTOAPPUSER '9AFE402D-1A7B-43AD-A8EA-15E3E0177273', @OWNERID, @BATCHID;

                return 0;
            end