@Federico & @Solomon, thank you very much for your complete and very informative answers.

Thanks. That is exactly what I was looking for.

The MSDN article I was referring to (http://msdn.microsoft.com/en-us/library/ms173497.aspx) states that:

Because DDL triggers are not schema-scoped and, therefore...

I don't see the benefit of creating a blank trigger. If trigger already exists creation of blank trigger would fail. If trigger does not exist drop trigger would...

May I expand a little bit on the question. How about conditional drop of the trigger?

Let's assume that I need a script which would recreate a trigger. So,...