In Microsoft Sql Server Management Studio Express (MS SSMS Express 2008), if you right click on a table you have the option to Select Top 1000 Rows or Edit Top 200 Rows.

You can change the number of rows by going to Tool, Options, Sql Server Object Explorer, Commands and change the Table and View Options.

Set the number to 0 to View or Edit All Rows.

Another choice is to right click on the table and View or Edit the number of rows given. Then right click on the grid, select Pane, SQL.

You can then modify the SQL adding a WHERE clause to find the rows you need.

Then execute the SQL by ctrl-r or selecting from the Query Designer menu or clicking the red exclamation point.