Menu

Want to work with us? We're on the lookout for a UX/UI Designer and Digital Project Manager.

We're hiring

How to return more than 200 records in SQL Server table edit.

Web Bureau


09 July 2013 by Web Bureau

Ok to change this from its default setting then just do the following:

  1. Open SQL Server Management Studio

  2. Goto: Tools > Options > SQL server Object Explorer > Commands  

  3. "Value for Edit top <n> rows command - change this to a number (i usually set this to '0')

Just be careful with the valuer that you specify as a large number in a large table  will result in reduced perfromance.

 Hope this is helpful!!!

 

 

 

Grow your businessStart a project with us today.