Tag: ssms | makolyte

Change ‘Edit Top 200 Rows’ and ‘Select Top 1000 Rows’

01/26/202506/25/2020 by Mak

In SQL Server Management Studio (SSMS), when you right-click on a table, it’ll show you the commands “Select Top 1000 Rows” and “Edit Top 200 Rows” in the context menu. You can change the number of rows these commands return. Here’s how to make this change: Now when you right-click a table, it’ll show the … Read more

Saving changes is not permitted in SQL Server

01/26/202506/25/2020 by Mak

Problem You’re trying to save a table change in SQL Server Management Studio (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 … Read more