As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to change the value of the option SELECT Top N rows
Sometimes you may need to view some sample rows from a table. In SSMS there is an option to do this. Expand to the table level.
Databases-->Your_db-->Tables. Now right click on the table and choose the option Select Top 1000 rows which will show the first 1000 rows in a new query window.
If you want to change this value, say from 1000 to 50, you can do the following
In the toolbar
Tools-->Options-->SQL Server Object Explorer. On the right side of the window change 1000 to 50 in the first row which is labelled as Value for Select top Audit records command
Other posts that come under Exploring SSMSEnabling Save ChangesEnable/Disable intelliSense
Tags: t-sql, sql_server, sqlserver, tsql, BRH, #SQLServer, SSMS, #BI,