Hi All
Thanks for your replies....I can see now how to edit all rows in Sql Server2008
Regards,
Gerard



>In the "Object Explorer" in SSMS, right-click the table you're interested in and choose "Open Table". You can make all the edits you want there, even if there are a lot of records.
>
>~~Bonnie
>
>
>
>
>>Hi.
>>In Sql server 2005, in SS management studio, it was possible to select ALL rows , edit any one of them and save.
>>It now just seems to be able to edit top 200
>>
>>Is there a way of showing ALL recirds in a table, edit the required ones and save
>>
>>Regards,
>>Gerard