Edit all rows insead of top 200 in SQL Server Management Studio

  1. Go to Tools > Options
  2. Open the last option, SQL Server Object Explorer
  3. Select Commands
  4. in each field you want to get unlimited records (Edit All), type 0

SQL OPTIONS

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s