Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

VB.net SQL You do not have permission to use the bulk load statement

Hi. I get the following error when trying to run the following SQL in my VB.net application "You do not have permission to use the bulk load statement"

CREATE TABLE myTable(Document varbinary(max)) 
INSERT INTO myTable(Document) 
SELECT * FROM 
OPENROWSET(BULK N'C:\Users\murbr\Pictures\MyFilter.jpg', SINGLE_BLOB) 

Open in new window

0
Murray Brown
Asked:
Murray Brown
  • 2
2 Solutions
 
Ryan ChongCommented:
try add in Server role: bulkadmin ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What kind of permissions do you have?
If you don't have sysadmin role then you'll need to have permissions for BULK OPERATIONS:
GRANT ADMINISTER BULK OPERATIONS TO <LoginName>

Open in new window

0
 
Ryan ChongCommented:
for my comment above
SnapShot.png
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now