The text of the CREATE TRIGGER statement is stored in the syscomments table. To see this text, execute the sp_helptext System Stored Procedure.
Note Triggers created with the ENCRYPTION option cannot be viewed with the sp_helptext system stored procedure.
The normalized tree for the trigger is stored in the sysprocedures table.
For a report on a trigger, execute the sp_help System Stored Procedure. For a report on the tables and views that are referenced by a trigger, use the sp_depends System Stored Procedure. To rename a trigger, use the sp_rename System Stored Procedure.
CREATE TRIGGER permission defaults to the table owner and is not transferable.