I have installed SQL Server 2000 with option "Client Tools Only
I try to edit data using SQL Query Analyzer with Trusted Connection. I click on 'Open' of right-click on table objects. A "Open Table Window" is opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit data.
I am trying to edit data using Server Explorer under Microsoft .NET with Trusted Connection. It works!!

Help, Help

The query analyzer use server side key set cursor to open table , it
requires that the table has unique index.
Otherwise it changes to static cursor, which is not updatable.

Server explorer use client side cursor, no such limitation.

Lishi Liu, VSData.