SQL Server – How to Change the “Edit Top 200 Rows” setting

by | Mar 4, 2011 | Blog, SQL Server

Found this here: http://tiny.cc/p8yk6

Go to Tools, Options, SQL Server Object Explorer, Expand this tree

Choose ‘Commands’ (Note: 0 = everything!)


(This shows the values after I changed them.  The default values are 200 for edit and 1000 for select.)

  • Taken: 4 March, 2011