SSMS – Change Select Top 1000 Rows or Edit Top 200 Rows

In SQL Server Management Studio (SSMS) it is possible to select the Top 1000 or edit the Top 200 rows in a table or view. When you right on a table or view in SSMS, you will see the Context menu below.

In this Context menu you can:
1. Select Top 1000 Rows
2. Edit Top 200 Rows

The idea behind this is for performance reasons. But what if you want to display all the records, or edit row 250 for example? In SSMS it is possible to change these default settings. To modify the “Select Top 1000 Rows” or “Edit Top 200 Rows”  settings do the following:

1. In SSMS click on  Tools | Options
2. Select SQL Server Object Explorer . Now you should be able to see the Table and View Options
3. To select/edit All records from a table or view, specify a value of 0 to return all rows.

SSMS Tools Pack (free)

Recently I wanted to export a configuration table with data from Microsoft SQL Server 2008 R2, through generating "INSERT INTO" scripts. Because it was a big (and frustating) search in SQL Server Management Studio (SSMS) to get this done, I went looking for a tool that could simplify this.

After some googling, I found SSMS Tools Pack. SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2, Denali CTP3 and their respective Express versions. It is a very useful tool, and free to use.

Download
Go to http://www.ssmstoolspack.com/Download

Features
Click here to view all the features of SSMS Tool Pack.