SQL Server Procedures, tables and triggers

• To Know about the details of Procedure: 
• sp_helptext yourprocedurename 

• To Know about the List of all Procedure in  a particular database: 
• select * from sysobjects where xtype='P'
• To Know about the List of all tables in  a particular database: 
• select * from sysobjects where xtype='U'
• To Know about the List of all trigger in  a particular database: 
• select * from sysobjects where xtype='tr'

• To Know about the List of all trigger on particular table: 
• sp_helptrigger yourtablename

• Enable/Disable Trigger

• ALTER TABLE table_name DISABLE TRIGGER tr_name 

• ALTER TABLE table_name ENABLE TRIGGER tr_name