title: You do not have permission to use the bulk load statement error
body: <p>I am trying to insert an image into a VARBINARY(MAX) column. I get this error: </p>
  
  <blockquote>
    <p>You do not have permission to use the bulk load statement.</p>
  </blockquote>
  
  <p>Here is my code:</p>
  
  <pre><code>INSERT INTO Stickers (Name, Category, Gender, ImageData)
         SELECT   
             'Red Dress',
             'Dress',
             'F',
             BulkColumn FROM OPENROWSET(Bulk '\\Mac\Home\Documents\MMImages\reddress.png', 
                                        SINGLE_BLOB) AS BLOB
  </code></pre>
  
  <p>I realise there are a lot of answers on this topic but none of them have worked for me. <a href="https://stackoverflow.com/a/13002720/3935156">This answer</a> would be the easiest one for me to follow, however when using the object explorer and going into security > logins > right clicking my user does not reveal a "properties" menu item to go into.</p>
  
  <p>I am using Sql Server Management Studio. Maybe I am not using the SQL Server version that I think I am, because none of the programmatic ways to set the permissions for my user worked. I think I am using SQL Server 2012. I probably have a few versions of SQL server on my computer. Clicking Help > About, it does show the logo "Microsoft SQL Server 2012" above the version information for various components (It does not show the version information for SQL Server here).</p>
  
  <p><strong>EDIT: Perhaps could someone please state the exact code I would use above my insert statement, given that the database is called MirrorMirror, the table is called Stickers, my user is called Amber, and my server is called gonskh1ou0.database.windows.net.</strong></p>