To display Month name instead of Month number in SQL Server

-- Consider following statement 
SELECT DATENAME(m, str(Month_Number) + '/1/2011')

-- for eg:
SELECT Year, DATENAME(m, Month + '/1/2011') AS Month,from calendar

-- Here m will be the output value

-- str(Month_Number) function convert month number to string i.e 2 => "2"

-- finally whole string "02/1/2011" is passed as argument

To get List of Triggers in SQL Server

SELECT trigger_name = sysobjects.name,
trigger_owner = USER_NAME(sysobjects.uid),
table_schema = s.name,
table_name = OBJECT_NAME(parent_obj),
isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'),
isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),
isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'),
isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),
isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'), [disabled] = OBJECTPROPERTY(id, 'ExecIsTriggerDisabled')
FROM sysobjects INNER JOIN sysusers ON
sysobjects.uid = sysusers.uid
INNER JOIN sys.tables t ON sysobjects.parent_obj = t.object_id
INNER JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE sysobjects.type = 'TR'