RE: Unable to edit data in table in Management Studio 2005

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

Hi Lena,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that after creatig table test table, we
will receive the following error when insert/update data into the table
manually
If I have misunderstood, please let me know.

"Data has changed since the Results pane was last retrieved. Do you want
to save your changes now? (Optimistic Concurrency Control Error)"

Based on my research, the issue might be a known issue, please try to
update the SQL Server to SP3.
please download the SQL Server 2005 SP3 via the following
http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-
8ae5-949fdfbe59c4&DisplayLang=en

To workaround the issue, please try to insert/update the date by T-SQL.

If there is anything unclear, please do not hesitate to let me know. Have a
nice day.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.

Relevant Pages

  • RE: Sql Server 2005 Setup will not run
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... Is there any SQL Server instance installed on the machine? ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.tools)
  • RE: automating running a stored procedure
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... If you use SQL Server express edition, since the SQL Agent Service is not ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • RE: Alias best way in SQL Server
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... application connect to the SQL Server? ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.server)
  • RE: Invalid Reference Error
    ... Welcome to Microsoft MSDN Managed Newsgroup. ... An MDE file is the same as a regular Access MDB database file, ... Microsoft Online Community Support ...
    (microsoft.public.access.forms)
  • RE: Cannot telnet to server from LAN
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... we could get the port number of the sql instance by SQL Server ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)