Unable to edit data in table in Management Studio 2005

Tech-Archive recommends: Speed Up your PC by fixing your registry

I'm having trouble editing data in a table in SSMS 2005, the way one could do
in Enterprise Manager. For example, I have this test table:

CREATE TABLE [dbo].[TestTable](
[TestID] [int] IDENTITY(1,1) NOT NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_TestTable_CreatedOn]
DEFAULT (getdate()),
[associateID] [varchar](512) NULL,
[employeeID] [varchar](512) NULL,
[fname] [varchar](512) NULL,
[lname] [varchar](512) NULL,
CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED
(
[TestID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

with one line of data
2 2008-08-01 00:25:57.570 158045 12345678 Lena Nilsson

In the left-hand pane I right-click the name of the table and select "Open
Table". Then I go in, click in one of the fields, make a change, and click on
another row to save it. Instead I get an error message "Data has changed
since the Results pane was last retrieved. Do you want to save your changes
now? (Optimistic Concurrency Control Error)" . When I click "Yes" to update
anyway, I get another error "No row was updated. ... Error Source:
Microsoft.VisualStudio.DataTools. Error Message: The updated row has changed
or been deleted since data was last retrieved." So far I have not been able
to make it save the data.

I've seen an article in the Knowledge base (KB925719) about this error, but
none of those circumstances apply to my table. According to the KB article,
this issue occurs if the following conditions are true:

* The table contains one or more columns of the text or ntext data type.
* The value of one of these columns contains the following characters:
o Percent sign (%)
o Underscore (_)
o Left bracket ([)
* The table does not contain a primary key.

I don't see any of those conditions applying to my table.

The system informatiion from SSMS Help, About is
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.3082
Operating System 5.1.2600

How can I get around this error?
.

Relevant Pages

  • Re: user can not run mmc errors include password GP and AD please read
    ... > So I have a user who has a problem running enterprise manager. ... > Windows cannot determine the user or computer name. ... If this post is viewed at a non-Microsoft community website, ... please direct all replies ONLY to the Microsoft public newsgroup ...
    (microsoft.public.windows.server.active_directory)
  • Re: Phone call log, multiple fields for different times
    ... TimeRangeID (an Autonumber field, the Primary Key) ... Microsoft IT Academy Program Mentor ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • RE: SSMS 2008 Super Buggy
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... when using SQL 2008 SSMS to dubug a sprocs, it seems that the SSMS hangs. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.tools)
  • Re: Table relationships
    ... type auto-number in the Project form, and long integer number in the Updates ... "Jeff Boyce" wrote: ... Microsoft IT Academy Program Mentor ... You set a primary key in design mode. ...
    (microsoft.public.access.formscoding)
  • Re: Table relationships
    ... type auto-number in the Project form, and long integer number in the Updates ... "Jeff Boyce" wrote: ... Microsoft IT Academy Program Mentor ... You set a primary key in design mode. ...
    (microsoft.public.access.formscoding)