June 13, 2003 at 5:20 pm
Hi everyone, I wanted to know what privilege my user needs to be able to run bcp. BOL did not have anything on this. Thanks in advance for your help.
June 13, 2003 at 6:38 pm
If you're planning to use QA then the user need permission to exec. xp_cmdshell
otherwise just the appropriate permissions to write data.
for bulk insert:
Your user has to be a member of the "Bulk Insert Adminstrators" role
which is a server wide role
Refer to "Bulk Insert" section "permissions" on BOL
MW
Edited by - mworku on 06/13/2003 6:49:33 PM
MW
June 13, 2003 at 6:42 pm
z
MW
MW
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy