title: DataAdapter error: the column exceeds the MaxLength limit
body: <p>The error occurs when I try populating a datasets datatable. </p>
  
  <pre><code>ds = dsMyDataset;
  sqlAdapter.Fill(ds, dsMyDataset.MyTable.TableName); // Uses the SQLAdapters 'select command'
  </code></pre>
  
  <p>On fill, I get this error: </p>
  
  <p><strong><em>Additional information</em></strong>: 'Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.'</p>
  
  <p>I run this command in the command window:  </p>
  
  <pre><code>dsMyDataset.MyTable.GetErrors()[0].RowError
  </code></pre>
  
  <p>And it informs me that "Column 'XMLHistory' exceeds the MaxLength limit."</p>
  
  <p>Odd because in the dataset's length property specifies a length of '2147483647'for that field. </p>
  
  <p>So in my sqladapter I specify a size: </p>
  
  <pre><code>sqlComm.Parameters.Add("@XMLHistory", SqlDbType.Text, 2147483647, "XMLHistory");
  </code></pre>
  
  <p>But this apparently does not help my issue out. Also noticed that the size in the DB for that column is '16'.</p>
  
  <p>Now here's an odd thing I noticed. What this program allows me to do is archive data from one DB to another. So I have a list of tables that the user can select from to archive. What's odd is that if I select one table it archives just fine. This issue as I've listed above doesn't actually fire until <em>after</em> the first table archives and the system attempts to move on to the second table. The moment it tries to fill the DS, booooom. Dead. </p>
  
  <p>Any suggestions/thoughts appreciated. Cheers. </p>