USE Database_name;
DELETE FROM Table_name
WHERE Date_column < GETDATE() - 100Month: September 2022
-
Delete all rows on the table that are older than 100 days
-
Fix broken permissions on Windows Server (or desktop)
Ever see The “Failed to Enumerate Objects in the Container. Access is denied.” error? I get this sometimes on Windows when pulling code from Git.
Here is quick fix:
- Open PowerShell as Administrator
- Run
takeown /F C:\fullpathToTheFolder
takeown /F C:\fullpathToTheFolder /r /d y
icacls C:\fullpathToTheFolder /grant Administrators:F
icacls C:\fullpathToTheFolder /grant Administrators:F /t - Then open File Explorer normally and you should be able to set permissions normally again.