Results 1 to 2 of 2

Thread: Bulk Insert

  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Unanswered: Bulk Insert

    I am trying to Bulk Insert into Database from a program in VC++ on to sql2000 database.My code was successful if i use the credentials of SA user.
    but i need to execute the same process with different user which has DBO privileges on the database in which i have the table.Can anyone tell me what privileges need to be granted for this dbo user to make bulk insert work.
    thanks a lot for your help.
    anna

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You need insert privleges on the table, which are included for dbo. You should be "good to go" for everything you've described so far.

    -PatP

Posting Permissions

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