View data of a table in sql server 2008

Question

I installed sql server 2008 and I can't view table data. When I rightclick on the table it shows select top 1000 rows, edit top 200 rows. How to view all the rows of my table?

Answer 1

I'm assuming you are trying to view all the records in a table and there are more than 1000? In that case

SELECT * FROM <table name here>

or select the "select top 1000 rows" option and then just remove the "TOP 1000" from the query

Answer 2

Try this, On the menu Select Tools-> Options->SQL Server Object Explorer->Commands Under Table and View Options you can alter the default value for "Value for Edit Rows command, and Value for Select Top Rows command