Microsoft KB Archive/302621

= BUG: Cannot Perform BULK INSERT with Bulkadmin Privileges =

Article ID: 302621

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q302621



BUG #: 354213 (SHILOH_BUGS)



SYMPTOMS
If a BULK INSERT command is issued by a user who
 * Is part of the bulkadmin server role and has INSERT permissions to the table
 * Is not part of the sysadmin, db_ddladmin, or db_owner role
 * Is not the database owner

The following error message is generated:

Server: Msg 8104, Level 16, State 2, Line 1

The current user is not the database or object owner of table ''. Cannot perform SET operation.



WORKAROUND
To work around the problem, make sure that the user is also part of either the db_ddladmin or the db_owner database role in addition to the bulkadmin server role. Another workaround is to make the user the owner of the database.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.

Additional query words: Bulk Insert bulkadmin sysadmin server role

Keywords: kbbug kbpending KB302621

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.