Solution

SQL Server replication uses max text repl size option as maximum size in bytes of text, ntext, varchar(max), nvarchar(max), varbinary(max), xml, and image data types to be replicated. Default value is  65536 and value of -1 means no limit. To solve this problem execute the following statement, which will reconfigure SQL Server:


EXEC sp_configure ‘max text repl size’, 2147483647

RECONFIGURE


This script will return real row sizes in a specified table, order by row size descending:

DECLARE @table VARCHAR(30)
DECLARE @idcol VARCHAR(10)
DECLARE @sql VARCHAR(MAX)
DECLARE @pos INT

SET @table = '<table_name>'
SET @idcol = '<id_column>'
SET @sql = 'select ' + @idcol +', ('

SELECT @sql = @sql + ' isnull(datalength(' + [name] + '), 1) + '
FROM syscolumns WHERE [id] = object_id(@table)
SET @sql = @sql + ') as rowsize from ' + @table + ' ORDER BY rowsize DESC'

SET @pos = LEN(@sql) - (CHARINDEX('+', REVERSE(@sql))-1)

-- remove last + sign from the query
SET @sql = LEFT(@sql, @pos-1) + ' ' + RIGHT(@sql, LEN(@sql) - (@pos) )
--PRINT (LEFT(@sql, @pos-1) + ' ' + RIGHT(@sql, LEN(@sql) - (@pos) ))
EXEC (@sql)

The following query gives a sizes of tables and number of records for the database:

select o.name
, reservedpages = sum(a.total_pages)
, usedpages = sum(a.used_pages)
, pages = sum(case when a.type <> 1 then a.used_pages
when p.index_id < 2 then a.data_pages else 0 end)
, SUM(a.used_pages)*8096 AS 'Size(B)'
, rows = sum(case when (p.index_id < 2) and (a.type = 1) then p.rows else 0 end)
from sys.objects o
join sys.partitions p on p.object_id = o.object_id
join sys.allocation_units a on p.partition_id = a.container_id
where o.type = 'U'
group by o.name
order by 3 desc

or similar:

SELECT
t.NAME AS TableName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
WHERE
t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
t.Name, p.Rows
ORDER BY
3 DESC

Error:
The row was not found at the Subscriber when applying the replicated command
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0013DD67000002EA007F00000000, Command ID: 1)

Solution:
The error is beacuse an update or delete statement cannot find rows in the subscriber database.

Execute the below command in the distribution database to find the row which its trying to access. Check if this row is existing in the subscriber database.

exec sp_browsereplcmds @xact_seqno_start = ‘0x0013DD67000002EA007F00000000’
,@xact_seqno_end = ‘0x0013DD67000002EA007F00000000’
,@publisher_database_id = xxx
,@article_id = xxx
,@command_id= ‘1’

You could also try the below query & check for command id 1

select * from dbo.MSarticles
where article_id IN (SELECT Article_id from MSrepl_commands
where xact_seqno = 0x0013DD67000002EA007F00000000)

It is probably because someone might have deleted that row from the subscriber.

Or

Enable -OutputVerbloseLevel to 2 in the distribution agent & get the exact statement.