Before create a trigger, consider that:
The CREATE TRIGGER statement must be the first statement in the batch. All other statements that follow in that batch are interpreted as part of the definition of the CREATE TRIGGER statement.
Permission to create triggers defaults to the table owner, who cannot transfer it to other users.
Triggers are database objects, and their names must follow the rules for identifiers.
For More InformationPlz follow this link:
http://technet.microsoft.com/en-us/library/aa214593(v=sql.80).aspx