Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Edit top 200 rows - how can I edit 400?

Author  Topic 

simy
Starting Member

2 Posts

Posted - 2009-05-01 : 07:00:51
Hi, I wonder if anybody would be kind enough to help me please.

Up until yesterday my hosting company was using sql 2000 and I used entreprise manager every few days to update some of the data held within 400 rows in a table. This worked great, I could simply cut and past rows if I wanted to replicate certain rows before making changes or just change the data in a field.

Now all this seems to be lost with management studio express 2008...
I need to edit about 400 rows. Is there an easy way around this?

many thanks

simy
Starting Member

2 Posts

Posted - 2009-05-01 : 07:06:59
I think I've just found the solution.

Go to tools - options - SQL server Oject Explorer and change 200 to 400.
Go to Top of Page
   

- Advertisement -