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