Orçun Polat

Select trigger_name = name, trigger_owner = USER_NAME(uid), 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'), status = CASE OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') WHEN 1 THEN 'Disabled' ELSE 'Enabled' END FROM sysobjects WHERE type = 'TR' order by name

EXEC sp_resetstatus db ALTER DATABASE db SET EMERGENCY ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (db, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE db SET MULTI_USER