How to Edit all Records in a SQL Server 2008 Table
This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200.

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.

Editing top 200

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...

Changing number of records

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.

Viewing all records

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!

This blog has 0 threads Add post