[Solved] SQL Server Error: You do not have permission to use the bulk load statement

Hi kankon,

Make sure you have the right permissions to use BULK commands.

• Expand Security
• Expand Logins
• Right click on your username and choose properties (A dialog window appears)
• Choose Server Roles
• Select bulkadmin to be able to use bulk commands or sysadmin to be able to use any commands to your database.

Reference:

https://stackoverflow.com/questions/32417776/you-do-not-have-permission-to-use-the-bulk-load-statement-error

dharmendr says:

Hi kankon,

Make sure you have the right permissions to use BULK commands.

• Expand Security
• Expand Logins
• Right click on your username and choose properties (A dialog window appears)
• Choose Server Roles
• Select bulkadmin to be able to use bulk commands or sysadmin to be able to use any commands to your database.

Reference:

https://stackoverflow.com/questions/32417776/you-do-not-have-permission-to-use-the-bulk-load-statement-error

UPDATE Table_infoname 
SET profileimage = (SELECT BulkColumn FROM OPENROWSET (BULK 'C:\img\1.png', SINGLE_BLOB) a)