April 2016 – Pinter Computing

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 NVARCHAR(MAX); DECLARE trigger_cursor CURSOR FOR SELECT trigger_object.name trigger_name, table_object.name table_name FROM sysobjects trigger_object JOIN sysobjects table_object ON trigger_object.parent_obj = …

Continue reading “Disable database triggers in Microsoft SQL databases”

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. –Disable foreign keys on all tables DECLARE @table_name SYSNAME; DECLARE @cmd NVARCHAR(MAX); …

Continue reading “Disable foreign key constraints in Microsoft SQL databases”

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/