To Disable all triggers, run this script, then run the results SELECT ‘ALTER TABLE ‘+ NAME +  ‘ DISABLE TRIGGER ALL’FROMsysobjectswhere XTYPE =‘u’   To Enable all triggers, run this script, then run the results SELECT ‘ALTER TABLE ‘+ NAME…

Sometimes we want to rename every table in a database, for example, Access has a habit of appending prefixes to tables instead of the schema, if we upload these again to sql we have a load of table names with…

Moving a SQL Database schema is easy, and I have been generating the scripts for this for a long time. But I recently learned that by digging into the advanced options, there is a well buried option to script the…

Keeping controls aligned can be tedious, but Visual Studio contains some features that make this easier. To Align controls, by their edges or centers, select first the control that is in the correct position, then hold down the ctrl and…