Enterprise Manager vs. Management Studio

Can anyone tell me how I can edit the data in a field under Management
Studio/SQL 2005 like I can do using Enterprise Manager/SQL 2000?
Under EM, I can use a 'SELECT * FROM table' query in the 'open table'
option (with any necessary criteria to limit the returned data) and
directly edit the results. While this is not the preferred method to
handle data, it works nicely is certain instances.
I can write an UPDATE query to do the same thing, but the EM method was
frequently much faster for certain updates.
Anyway: when I try to do what seems like the equivalent in MS, I keep
getting errors about "Data has changed since the Results pane was last
retrieved" even though I know that to be false (I'm the only user in the
database, and the table I'm editing is used for lookup by the app). When
I try to commit the changes, it complains that it cannot update the row.Right click on the table in Object Explorer. Click "Open Table".
On Jul 12, 11:26 am, horseradish <millar...@.gmail.com> wrote:
> Can anyone tell me how I can edit the data in a field under Management
> Studio/SQL 2005 like I can do using Enterprise Manager/SQL 2000?
> Under EM, I can use a 'SELECT * FROM table' query in the 'open table'
> option (with any necessary criteria to limit the returned data) and
> directly edit the results. While this is not the preferred method to
> handle data, it works nicely is certain instances.
> I can write an UPDATE query to do the same thing, but the EM method was
> frequently much faster for certain updates.
> Anyway: when I try to do what seems like the equivalent in MS, I keep
> getting errors about "Data has changed since the Results pane was last
> retrieved" even though I know that to be false (I'm the only user in the
> database, and the table I'm editing is used for lookup by the app). When
> I try to commit the changes, it complains that it cannot update the row.|||Jason Lepack wrote:
> Right click on the table in Object Explorer. Click "Open Table".
That is what I'm trying to do. Is there something I've got set in the
connection properties that is causing this? I haven't changed any of the
defaults, so I'm not sure what should be updated to get the behavior back.

> On Jul 12, 11:26 am, horseradish <millar...@.gmail.com> wrote:
>|||On Jul 13, 2:39 pm, horseradish <millar...@.gmail.com> wrote:
> Jason Lepack wrote:
> That is what I'm trying to do. Is there something I've got set in the
> connection properties that is causing this? I haven't changed any of the
> defaults, so I'm not sure what should be updated to get the behavior back.
>
>
>
>
>
> - Show quoted text -
That is odd behavior, I just tested it here and the Open Table
functionality allows me to edit directly in the grid view, which is
what you are looking to do. Are you opening the same table in EM and
it is working? The only time I've seen it now allow updating directly
from the grid is if a Primary Key is not specified on the table. I'm
not an expert, but sounds like something is off, especially if opening
the same table in EM works but not in SSMS.|||> That is odd behavior, I just tested it here and the Open Table
> functionality allows me to edit directly in the grid view, which is
> what you are looking to do. Are you opening the same table in EM and
> it is working? The only time I've seen it now allow updating directly
> from the grid is if a Primary Key is not specified on the table. I'm
> not an expert, but sounds like something is off, especially if opening
> the same table in EM works but not in SSMS.
>
I created a registration to a SQL2000 host/instance and tried to edit a
field in grid view using SSMS, and received the error posted (Data has
changed since the Results pane was last retrieved/Optimistic Concurrency
Control Error) earlier in the thread.
I then opened EM and was able to edit the _exact_ _same_ field
(server\instance\database\user\table) in 'grid view.'sql