Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Unanswered: bulk insert not working

    i MADE A USER AS bULK aDMIN BUT HE STILL CAN'T BULK iNSERT TO A TABLE . He has dd_writer and dd_reader roles assigned in database .


    What should I do to fix this . Here is the error

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

  2. #2
    Join Date
    Dec 2003
    Posts
    31
    does the database bulk insert flag is on?

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Keep in mind only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •