That's correct. That query does not return any records.

The server in question is Enterprise Edition.

I've used both SA and my own windows credentials that is a sysadmin role.

No I haven't resolved it. Are you having the same problem?

SQLDMO doesn't expose triggers that I can see(via Intellisense on oSQL). How could this script be modified to include the scripting of triggers?