Change select and edit top 1000 rows command in MS SQL



If you use 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.







EmoticonEmoticon