Post reply

string or binary data would be truncated

  • May 28, 2004 at 2:06 pm

    #82974

    Hi everyone,

    I've posted the same thread in the General forum, but since that forum is probably more appropriate, i'm posting it another time just to make sure.

    We're using Sql Server 2000 sp3a.

    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 2:11 pm

    #508291

    Can you post some sample DDL and DML? That's a strange one. I'd still suspect that it's a data issue, but it could possibly be some bug.

  • May 28, 2004 at 2:15 pm

    #508293

    Actually Steve i can reproduce the problem at will using just a browse table in enterprise manager and updating a column. Doing the same operation with the same user but with the sysadmin role, it's works just fine!!!

  • May 28, 2004 at 4:01 pm

    #508308

    A few thoughts:

    1. Run DBCC USEROPTION when user gets this error and when he doesn’t (when he is a member of sysadmin role)

    2. Try SET ANSI_WARNINGS OFF for user's session (use SQL Query Analyzer) and see what happens.

    HTH,

    Igor

Viewing 4 posts - 1 through 3 (of 3 total)

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