need to disble to group of triggers

[seiamerica]

I need steps to disable triggers starts with 'act' and enable group of triggers starts with lbb

Thanks for your help

 

[Jamfool]

you can alter the following to your reqs:

select
'Disable Trigger' = 'ALTER TABLE ' + quotename(object_name(parent_obj)) + ' DISABLE TRIGGER ' + quotename([name]),
'Enable Trigger' = 'ALTER TABLE ' + quotename(object_name(parent_obj)) + ' ENABLE TRIGGER ' + quotename([name]),
trigger_name = [name],
trigger_owner = user_name(uid),
isupdate = ObjectProperty( id, 'ExecIsUpdateTrigger'),
isdelete = ObjectProperty( id, 'ExecIsDeleteTrigger'),
isinsert = ObjectProperty( id, 'ExecIsInsertTrigger'),
isafter = ObjectProperty( id, 'ExecIsAfterTrigger'),
isinsteadof = ObjectProperty( id, 'ExecIsInsteadOfTrigger'),
object_name(parent_obj) as 'Parent Table'
from sysobjects
where type = 'TR'