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.
annaYou 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment