[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 140
  • 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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