PRB: You Cannot See the Edit Insertion Point in SQL Server Enterprise Manager When You Edit a Table Row (324711)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q324711

SYMPTOMS

If you install the US English version of SQL Server 2000 on a native Hebrew version of Windows 2000, you cannot use SQL Server Enterprise Manager to edit the rows in the table.

For example, use SQL Server Enterprise Manager to expand the tables in the pubs database:
  1. Right-click the authors table.
  2. Click Open table, and then click Return All Rows.
  3. Click a row, and then try to edit any value in a column. You notice that you cannot see the edit insertion point, and you cannot see what you type until you click another cell in the table, at which point you can see the modifications that you made.
This problem makes it very hard to edit tables through SQL Server Enterprise Manager.

This bug was reproduced on computers that were running Microsoft Windows 2000 Professional (Hebrew-Native) and Microsoft Windows XP Professional (Hebrew).

WORKAROUND

To work around this problem, use any of the following methods:
  • Use the scripting functionality in the Object Browser tool to generate the Transact SQL scripts for editing the objects. For more information, see the "Using the Scripting Feature in Object Browser" topic in SQL Server Books Online.
  • Use Query Analyzer instead of SQL Server Enterprise Manager to edit the table.

    For example:
    UPDATE [pubs].[dbo].[authors]
SET [phone]='408 496-7223'
WHERE au_id = '172-32-1176'
  • Install the US English version of the operating system instead of native Hebrew version.

STATUS

Microsoft is researching this problem and will post more information in this article when the information becomes available.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbpending kbprb KB324711
©2003 Microsoft Corporation. All rights reserved.