title: Changing nvarchar fields fails in SQL Server Management Studio 2008 R2 with weird message
body: <p>I'm trying to edit a value in a table with about 50 columns using SQL Server Management Studio 2008 R2 (10.50.2500.0). One of the columns is a normal standard text column for email (no constraints, no FKs, nothing):</p>
  
  <pre><code>CREATE TABLE [dbo].[Members](
      [Id] [uniqueidentifier] NOT NULL,
            ....
      [Email] [nvarchar](250) NOT NULL,
            ....
  </code></pre>
  
  <p>I do right-click on the table, click "Edit top 200 rows", choose a row and update email from "aaa" to "bbb". I get this error message when I try to leave the row:</p>
  
  <blockquote>
    <p>Microsoft SQL Server Management Studio</p>
    
    <p>No row was updated.</p>
    
    <p>The data in row 2 was not committed. Error Source: mscorlib. Error
    Message: Offset and length were out of bounds for the array or count
    is greater than the number of elements from index to the end of the
    source collection.</p>
    
    <p>Correct the errors and retry or press ESC to cancel the change(s). </p>
    
    <p>OK   Help   </p>
  </blockquote>
  
  <p>If I update the value using SQL script, it works just fine:</p>
  
  <pre><code>UPDATE [dbo].[Members] SET [Email] = 'bbb' WHERE Email = 'aaa'
  </code></pre>
  
  <p>Any idea what's going on here? Thanks!</p>