When you create a trigger using Create Trigger Syntax, where exactly that trigger is getting stored? Can I see its properties in the enterprise manager? Thanks in advance.

You can find it within sysobjects table. Also on EM, you can see its properties by right clicking its related table, then select All Tasks >> Manage Triggers option from the shortcut menu. The combo box displayed there lists the triggers written for that table.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection