December 30, 2005 at 2:35 pm
In EM, a user right clicks on a table, select 'Open Table' and 'Return all rows'. It appears SQL EM would not allow the user to change the data in more than 5 or 10 rows at a time. Is there a setting that controls how many rows may be edited? We have SQL Server 2000 (SP3).
Thanks in advance, Kevin
December 30, 2005 at 3:26 pm
Well you can always scroll to see the rest of the data (if there's any). Also I'd strongly suggest you use Query analyser to make changes as they are easier to spot and undo than manual editing.
December 30, 2005 at 10:15 pm
I have also faced this problem. But just now i have checked i have changed two rows but when i changed third row it gives me message.
January 2, 2006 at 3:52 am
In most cases, it is better not to use EM for editing. There is only one situation in which I have ever edited values in a table through EM, and that was auxiliary table for my own use - I was adding some descriptions to it and was lazy to code the update. I would never edit a table in production. That being said, I had no problems editing about 50 rows at once (i.e. one after another, but without interruption or errors).
Please, could you post the error message? It would be very helpful to know what the error is. There is a certain time, after which the table is closed to save resources and you have to open the table again. Also, you can get error message if you try to edit a row that is not uniquely identifiable (the update would affect more than one row). Maybe there are other, these are the only I remember at the moment.
HTH, Vladan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply