Want to work with us? We're on the lookout for digital experts.

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.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.