SSMS – Change how many rows are returned by SELECT Top 1000 Rows

When you right-click a table in SSMS, you can “Select Top 1000 Rows” and “Edit Top 200 Rows.” You can change how many rows are returned by changing the defaults. Tools SQL Server Object Explorer Change the values under Table and View Options Change these values to whatever makes sense in your situation. Note: if … Read more SSMS – Change how many rows are returned by SELECT Top 1000 Rows

SSMS – How to turn off “Prevent saving changes that require table to be re-created”

Problem You’re trying to save a table change in SSMS and you get the error message: Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes … Read more SSMS – How to turn off “Prevent saving changes that require table to be re-created”