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 do not appear in the sys.objects catalog view, the OBJECT_ID function cannot be used to query whether they exist in the database. Objects that are not schema-scoped must be queried by using the appropriate catalog view. For DDL triggers, use sys.triggers.
That was the reason for my confusion. Thanks again.