title: Records are missing in edit top 200 rows but can be viewed in select top 1000 rows SQL Server 2008 R2
body: <p>I am trying to Insert new data in table using "Edit top 200 rows" and I can view Inserted data by select top 1000 rows. so far so good. But when I am trying to find (close edit 200 row window) those Inserted data in same table by selecting "Edit top 200 rows" again, those data are missing and I am not able to find them.</p>
  
  <p>(p.s. But I can see those missing data in same table by select top 1000 rows though.) </p>
  
  <p>I am using SQL Server 2008 R2.</p>
  
  <p>I observed that my data table rows are more than "200" and It could be a reason for that. Do I need to make any changes to default size? Tool---options---sql server object explorer and them make changes to default row values?) Please excuse me If my question is not enough clear.</p>
  
  <p>I appreciate any Inputs. </p>