Skip to content

SQL Server – Management Studio Tip – Change Select Top 1000 Rows command

by manoj.desai on August 21st, 2015

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!!!!

In SQLS Enterprise Management Studio, go to Tools > Options > SQL Server Object Explorer > Commands and change the values as you see fit.

2015-08-21_13-56-59

 

From → SQL Spatial

Comments are closed.