title: Help with OPENROWSET in SQL Server (Impersonation issue)
body: <p>Basically I am looking to select the contents of a pdf into a table.</p>
  
  <p>I am using this query:</p>
  
  <pre><code>SELECT *
  FROM   OPENROWSET(BULK N'\\Server\Share\filename.pdf', SINGLE_BLOB) rs
  </code></pre>
  
  <p>The query won't run because my username doesn't have permissions on that server (nor should it), but I need to be able to authenticate as a different user to execute this query.  </p>
  
  <p>It probably won't be an issue in production as I believe the account running the command will have the proper permissions, but as it is, <i>I would like to be able to "impersonate" this user (I obviously have its credentials) and run the query from my account.  Any ideas on how to do this?</i></p>
  
  <p>Thanks...</p>