Category Archives: MSSQL



Error message when you try to save a table in SQL Server: “Saving changes is not permitted”

If you have freshly installed mssql with default settings, you can get the following error while updating your existing table. Error Message: “Saving changes is not permitted” Screenshot as follows: Causes: Prevent saving changes that require the table re-creation option is enabled and you have one or more changes to the table 1)You change the […]

Read More...


WITH (NOLOCK) IN MSSQL

Nolock statement in MSSQL comes handy when you are running a SQL statement (select statement ) against lots of records for example report generation.It will speed up the query execution. For example: SELELCT * FROM TABLE WITH(NOLOCK) Issues with NOLOCK STATEMENT Uncommitted Dependency(Dirty Read)        Uncommitted dependency occurs when a second transaction selects […]

Read More...