ID Number: Q82236
1.10 1.11
OS/2
buglist1.10 buglist1.11
Summary:
Problem ID: PRSQL9202017
SYMPTOMS
A user trying to BCP data into a table receives the following error
message:
MSG 2710, Level 0, State 16:
You are not the owner specified for the object named
'pubs.user1.u1_table' in this command (CREATE, ALTER,
TRUNCATE, UPDATE, STATISTICS, or BULK INSERT). The
database owner can use the SETUSER command to assume
the identity of another user.
CAUSE
According to the SQL Server documentation, a user that has INSERT
permission on a table and SELECT permission on SYSINDEXES,
SYSOBJECTS, and SYSCOLUMNS is allowed to BCP data into that table.
However, SQL Server incorrectly generates MSG 2710 and will not
allow the user to BCP the data in.
WORKAROUND
The work around is to have the system administrator (SA), database
owner (DBO), or the owner of the object load the data using BCP.
STATUS
Microsoft has confirmed this to be a problem in SQL Server versions
1.1 and 1.11. This problem was corrected in version 4.2.
Additional reference words: 1.10 4.20