Post reply

string or binary data would be truncated

  • May 28, 2004 at 1:28 pm

    #82699

    Hi everyone,

    I'm receiving this error when a particular user is trying to do an update. This error occurs on every tables of the database, from different pc's, using Enterprise Manager. We are receiving the same error from a vb application using the same user to access the database. It works fine with other users with the same security privilege. Strangely enough, if i gave the user the sysadmin role it works fine, but dbowner and datawriter privilege pops up this error.

    It's not a problem with the length of the field i'm trying to update, since the same operation is working with the sysadmin role.

    Anyone has any idea?

    Thanks in advance

    Denis Desjardins 

  • May 28, 2004 at 1:30 pm

    #508284

    Just a precision, we are using Sql Server 2000 Sp3a....

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply