Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Blog

FIXED – SQL Saving changes is not permitted

Wanted to share quick fix for SQL Server Management Studio (SSMS) when updating table schema design.  Cheers. 

shades_smile

Error

Saving Changes is not permitted. The changes 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 that require the table to be re-created.

Fix

  1. Launch SQL Management Studio
  2. Clink menu “Tools > Options
  3. Expand menu “Designers” and uncheck box “Prevent saving changes that require table re-creation.”


Screenshots

image
image

VIDEO – Azure Apps – Detect and Remediate Grants with PowerShell

PowerShell code below will enumerate App Registrations on Azure tenant with line item detail for all Permissions granted.   Security and compliance tool to help ensure API grants are only open for valid applications.   Excel pivot tables and charts can be used to filter grants by permission, application, and more.  Also this PowerShell script can be scheduled for regular monitoring of changes.  Cheers 

shades_smile

Video

Screenshots

image
image

References

What’s in that patch? Sep 2020

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes. Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at https://sharepointupdates.com/ If you found this helpful, please leave a comment.   

shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Sep 2020.PDF


What’s in that patch? Aug 2020

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes. Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at https://sharepointupdates.com/ If you found this helpful, please leave a comment.   

shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Aug 2020.PDF


© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲