[Solved] String or binary data would be truncated in SQL Server by user

Question

Of course this is specific to the data in the insert. If one user has a longer name than the field you are entering it into for example and another doesn’t, the first will error and the second will not. This is why it is critical to understand your data when setting up tables. and it is critical to understand what information you are sending in a specific action query in order to troubleshoot it.

Accepted Answer

Of course this is specific to the data in the insert. If one user has a longer name than the field you are entering it into for example and another doesn’t, the first will error and the second will not. This is why it is critical to understand your data when setting up tables. and it is critical to understand what information you are sending in a specific action query in order to troubleshoot it.