SQL Server Management Studio change Select Top 1000 Rows

In this article we will see how we change "SQL Server Management Studio change Select Top 1000 Rows".

If you are using SQL Server Management Studio, you know how annoying it is when you try to select records from a table and the UI limits you to the Top 1000 records. Well there is a way to change it!!!!

Go to Tools > Options > SQL Server Object Explorer > Commands and change the values as you see fit.

1àOpen SQL Server under tool section click on option

Now, it will open another window click on  SQL Server Object Explorer.

2àChange the new value for Value for Edit Top  and Change the Value for Select     Top. In the below example we have set the value as 5000 for both options.

3àClick OK to save the changes.

4àRight click the table to see the changes.

Post a Comment

Post a Comment (0)

Previous Post Next Post