Re: Cannot perform BULK INSERT even though the account is a bulkadmin

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 03/10/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Mon, 10 Mar 2003 17:43:14 -0000

Found the KB article that describes this issue

BUG: Cannot Perform BULK INSERT with Bulkadmin Privileges
http://support.microsoft.com/default.aspx?scid=kb;en-us;302621 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Duck Dunn" <x@outerinternet.com> wrote in message
news:3e63b159$1@news.microsoft.com...
> We have a stored procedure that dynamically constructs a BULK INSERT
> statement string and executes it. The account that executes this stored
> procedure is not the DB owner or table owner, but has been given "Bulk
> Insert Administrator" server role.
>
> We get the following error while executing this stored procedure:
>
> The current user is not the database or object owner of table
> 'PreStageOrganization_AATP'. Cannot perform SET operation.
>
> Pl let us know what permissions are missing for this operation.
>
> Thanks
>
>

Relevant Pages

  • Cannot perform BULK INSERT even though the account is a bulkadmin
    ... We have a stored procedure that dynamically constructs a BULK INSERT ... The account that executes this stored ... procedure is not the DB owner or table owner, ...
    (microsoft.public.sqlserver.security)
  • HELP..
    ... I tried by making the owner of the job as 'sa' and starting the job manually ... >> SQL SERVER 7.0 ... >> I created a SQL job which executes a stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: Generating one table with a terabyte of data
    ... Pretty much disabled the transaction log completely. ... We are using BULK INSERT ... for all those who don't know, SQL server prefers smaller BULK ... ORACLE seems to handle that 1 big file really well but with small files SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Recordset.AddNew and the recordset objects data retaining
    ... I am in an environment where bulk insert isn't an option--even though the ... underlying database is SQL server, I am using a third party OLE DB provider-- ... > insert(assuming you are using SQL server) or DTS. ...
    (microsoft.public.data.ado)
  • Re: Can Indexes effect Bulk Insert/Update Operations
    ... Columnist, SQL Server Professional ... becuase some operations need to be performed before insert/update the ... "Tom Moreau" wrote in message ... > unique/pk constraints before bulk loading the tables. ...
    (microsoft.public.sqlserver.programming)