Records are missing in edit top 200 rows but can be viewed in select top 1000 rows SQL Server 2008 R2 -

Records are missing in edit top 200 rows but can be viewed in select top 1000 rows SQL Server 2008 R2 -

i trying insert new info in table using "edit top 200 rows" , can view inserted info select top 1000 rows. far good. when trying find (close edit 200 row window) inserted info in same table selecting "edit top 200 rows" again, info missing , not able find them.

(p.s. can see missing info in same table select top 1000 rows though.)

i using sql server 2008 r2.

i observed info table rows more "200" , reason that. need create changes default size? tool---options---sql server object explorer , them create changes default row values?) please excuse me if question not plenty clear.

i appreciate inputs. in advance.

edit top 200 rows - of course of study not going see more rows 200. edit top 200 rows not way check if info exists in table.

that said, can increment number of rows visible in "edit top nnn" doing following:

in sql server management studio:

open "tools" menu click "options" expand "sql server object explorer" expand "table , view options" change value of "value edit top rows command" number of rows want appear when edit.

if dealing big tables, improve off doing modifications sql rather using edit interface.

sql sql-server table sql-server-2008-r2