Friday, October 24, 2014

String or binary data would be truncated.

When running an update in SQL Server 2005, I receive String or binary data would be truncated error. It's strange because it's a simple update and there's no varchar field involved. There's a update trigger in the table. Solution: I receive this error when I login to management studio with Windows Authentication. If I login with a sql server user, I can succesfully execute the update statement.