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.
No comments:
Post a Comment