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.