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