INSERT INTO ###Debug(SomeMessage, SomeData)
VALUES ('row count', @@ROWCOUNT)

IF @@ROWCOUNT = 0
BEGIN
    ROLLBACK TRANSACTION
    BREAK
END

DBCC FREEPROCCACHE
GO
DROP PRCOEDURE SB_..._Consume
GO
CREATE PRCOEDURE SB_..._Consume ...