Disable database triggers in Microsoft SQL databases
No Comments on Disable database triggers in Microsoft SQL databases
If you need to temporarily disable triggers in Microsoft SQL databases during database maintenance use the following script --Disable triggers on all tables DECLARE @enable BIT = 0; DECLARE @trigger SYSNAME; DECLARE @table SYSNAME; DECLARE @cmd…
Disable foreign key constraints in Microsoft SQL databases
Databases do not allow the deletion of rows if those are referenced in other tables with the foreign key constraint. You can turn off the validation of foreign keys in Microsoft SQL databases for the duration of the maintenance with the following script.…
Free Windows Virtual Machines for all major Internet Explorer versions by Microsoft
Microsoft published free Windows virtual machines for every major Internet Explorer version for multiple virtualization platforms. https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/windows/