Yup Journeyman, this is the answer to my question.

Sorry guys if the question was ambigous...I know how to write sql to "script" disable trigger (that's why I didn't post...

Ok, I know about that, but the question was: can you script DISABLE TRIGGER from SSMS?

If you need dynamic number of columns, the only way I know to do it is with dynamic sql.

Sorry, replace Transaction 1 and Transaction 2 with Insert 1 and Insert 2. As it is, it might give an impression of nested transactions and that's not the case. Inserts...

Tnx, this is a great solution, didn't come to mind when I was writing the code (it was more classic "hurry up" approach 🙂 ), although I did wrote few...

I'm all for declarative and rarely or almost never use while loops or cursors, but how would I go about doing this without while loop...btw I'm writing this in a...