Hi kaze,
While bulk inserting you must make sure that the user bulk inserting the
table should be owner of the table the user is bulk inserting to.

This error can be solved by changing owner of the object to the 'user' bulk
inserting the data or make the user sa

Deepak Nair
Gator Corporation
650-232-0367

-----Original Message-----
From: Kaze [mailto:[Email Address Removed] Monday, June 10, 2002 12:03 PM
To: Sissi Malek; [Email Address Removed] Bulk Insert in SQL2000



Hi,
Anyone have bulk insert issues in SQL2000. My users are getting a bulk
insert error.
"Server: Msg 8104, Level 16, State 2, Line 1
The current user is not the database or object owner of table 'XXX'. Cannot
perform SET operation."

I've checked the user permission. User has insert rights and i've also set
the "select into\buck copy" to TRUE in sp_dboption. I've also granted the
BULKADMIN fixed server role for the logins. And yet i am getting this
error. Is there anyway around this?
thanks!
kaze



---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup
MS Sql Server LazyDBA home page