Enterprise Manager - slow updates when editing tables

Hi,

I have a table with about 70k rows. When I use open table --> return
all rows and then edit a field Enterprise Manager then says it has to
return the entire result set for the update to take place.

This can take a long time and makes editing data a slow process. Is
there any way to get Enterprise Manager just to update the one row??

Thanks Tomtom.richards@.rocketmail.com (Thomas Richards) wrote in message news:<f118866.0408270102.5e0340e4@.posting.google.com>...
> Hi,
> I have a table with about 70k rows. When I use open table --> return
> all rows and then edit a field Enterprise Manager then says it has to
> return the entire result set for the update to take place.
> This can take a long time and makes editing data a slow process. Is
> there any way to get Enterprise Manager just to update the one row??
> Thanks Tom

The best solution is simply not to use Enterprise Manager - it's a
useful tool, but it's more useful as an administration tool than for
programming or data manipulation. In Query Analyzer, just use a simple
UPDATE:

update dbo.MyTable
set MyColumn = 'foo'
where PrimaryKey = 1

It's probably a good idea to use QA for this kind of thing, as EM has
a number of limitations, and QA allows you to control what's happening
more precisely.

Simon