I tried on building transactional replication connecting the systems within same domain
while creating the publisher and subscriber given the domain credentials as in the windows account.
Snapshot Agent and Log Reader Agent are not throwing any error. But when checking on Job history the following error is thrown
[SQLSTATE 22001] (Error 8152).
Detect nonlogged agent shutdown.,,Executed as user: NT SERVICE\SQLSERVERAGENT. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed.,00:00:00,16,8152,,,,0
The exception type is
Exception Type: Microsoft.SqlServer.Replication.ConnectionFailureException
Someone please help on this....
An 8152 error occurs when a value is inserted into column which does not fit, i.e. insert a varbinary(5000) value into a varbinary(500) column.
Can you run profiler to see which command it is failing on?
Brandon Williams (blog |
Just as Brandon post above, you can run SQL profiler to trace the failed transaction. You can also use sp_helpsubscriptionerrors to display the of list invalid transactions.
The following thread is about the similar issue,please refer to:
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?