The default is
SET NOCOUNT OFF
which displays informational messages - like "50,000 row(s) processed" - that will show the number of records that are deleted. But its a bit useless to be honest!
More typically in Procedures we use
SET NOCOUNT ON
which turns the no-ouput ON - double negative, very complicated. This STOPs the informational message.
There is a system variable that will tell you the number of rows processed, you can display that how-you-wish:
DECLARE @intRowCount int,
SELECT @intRowCount = 1, -- Force first loop iteration
@intTotalRows = 0
WHILE @intRowCount >= 1
SET ROWCOUNT 50000 -- Restrict ALL subsequent operations to 50,000 rows
DELETE FROM MyTable WHERE ...
SELECT @intRowCount = @@ROWCOUNT, -- Rows actually deleted
@intTotalRows = @intTotalRows + @intRowCount
SET ROWCOUNT 0 -- Remove the restriction
SELECT [Total rows deleted] = @intTotalRows -- Resulset output
PRINT 'Total rows deleted ' + CONVERT(varchar(20), @intTotalRows) -- Informational message alternative