SSMS 2008: change default SELECT/EDIT TOP (n) rows command

SQL Server Management Studio 2008 introduces 2 new ways of interact with data: SELECT and EDIT rows.
These 2 command have 2 different defaults values about number of rows to interact on: 200 rows for SELECT command, 100 rows for INSERT command.

These values can be changed, this way:
menu \ TOOLS \ OPTIONS \ SQL Server Object Explorer,
expand tree (COMMANDS and SCRIPTING sub nodes),
select COMMANDS,
then insert your new values for INSERT and SELECT command.

source: SQL 2008 – Change “Edit Top 200 Rows”



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: