A trigger is a stored procedure that runs automatically when various events happen (update, insert, delete, etc.) To display the contents of a Trigger, use a query similar to the following:
exec sp_helptext @objname = 'StoredProcedureName'
