Q:

Changing nvarchar fields fails in SQL Server Management Studio 2008 R2 with weird message

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):
CREATE TABLE [dbo].[Members](
    [Id] [uniqueidentifier] NOT NULL,
          ....
    [Email] [nvarchar](250) NOT NULL,
          ....

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:

Microsoft SQL Server Management Studio
No row was updated.
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.
Correct the errors and retry or press ESC to cancel the change(s). 
OK   Help   

If I update the value using SQL script, it works just fine:
UPDATE [dbo].[Members] SET [Email] = 'bbb' WHERE Email = 'aaa'

Any idea what's going on here? Thanks!

A:

hmm... i think i found the answer:
http://social.msdn.microsoft.com/Forums/eu/vstsdb/thread/4ea43c84-15c8-4f63-967f-6944f1d71660
http://connect.microsoft.com/SQLServer/feedback/details/155528/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
looks like a known bug in SQL Server Management Studio.

