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

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!!!