BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andrew Gould on 16 February 2012
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Viewing or Editing all the Records in SQL Server 2008
In SQL Server 2008 and onwards when you choose to view or edit the records in a table you can only do so to a limited number of records.
By default, when you right-click on a table you can only view the first 1000 and edit the top 200 records in a table.
Fortunately, you can change a setting to allow you to view and edit all the records. To do this, from the menu choose: Tools -> Options...
Expand the SQL Server Object Explorer group and click Commands. Change the Table and View Options shown here to any number you like. If you enter a value of 0 you will see all of the records in a table.
Once you've done this you can right-click on a table and view or edit all of the records in a table.
Now you can view or edit an entire table.
It's annoying to have to do this, but at least now you know how to!