Enterprise Manager - slow updates when editing tables

[Thomas Richards]

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

[Simon Hayes]

to**********@rocketmail.com (Thomas Richards) wrote in message news:<f1*************************@posting.google.c om>...

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