title: Retrieving encrypted column 'xxx' with CommandBehavior=SequentialAccess is not supported
body: <p>I have setup a Azure SQL Database and enabled Always Encrypted.</p>
  
  <p>One of the column (column3) is <code>varchar(Max)</code>.</p>
  
  <p>When I query the database from SSMS without using <code>"column encryption setting=enabled"</code>, I can see that all the columns have binary data.</p>
  
  <p>When I query the database from SSMS using <code>"column encryption setting=enabled"</code>, I am getting an error as below:</p>
  
  <blockquote>
    <p>An error occurred while executing batch. Error message is: Retrieving encrypted column 'column3' with CommandBehavior=SequentialAccess is not supported.</p>
  </blockquote>
  
  <p>This is what my table definition looks like:</p>
  
  <pre><code>CREATE TABLE [dbo].[mytable](
      [column1] [varchar](2000) ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL,
      [column2] [datetime] ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL,
      [column3] [varchar](max) ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL
  )
  </code></pre>
  
  <p>If I remove the encryption on column3, everything works fine and I can see decrypted values.</p>
  
  <p>Am I missing something here?</p>
  
  <p><a href="https://i.stack.imgur.com/WB32N.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WB32N.jpg" alt="enter image description here"></a></p>