8152 - the dreaded message String or binary data would be truncated.
Exactly at which point does it happen?
Review what names you have in your environment? Maybe there something which unusually long?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I get error [SQLSTATE 22001] (Error 8152) when creating publisher even when following these instructions on sql 2019
8152 - the dreaded message String or binary data would be truncated.
Exactly at which point does it happen?
Review what names you have in your environment? Maybe there something which unusually long?
Hi @Peter Viau ,
The error message you're receiving indicates that the value you're trying to insert or update is too long for the column it's being inserted into. At what step did you get this error? Can you give more details?
Do you have insert operations in your database? If so, you can do the following checks.
This can occur when creating a SQL Server replication publisher if the length of one of the parameters exceeds the maximum length of the column it's being inserted into. Here are a few steps you can take to troubleshoot this issue:
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".