I had tried the script recommended by MS a long time before posting my questions. It appears to be addressing completely different issue. I see my trigger in the DB...

Thanks for your help.

lawprod is the owner of the table and UTR_Duplicate_REQ is a trigger as per sysobjects, so nothing is wrong in the syntax. Here is the script:

CREATE TRIGGER UTR_Duplicate_REQ...

It's my trigger, nothing else.