|
/*script out the disabling of triggers */
--TODO: when disabling triggers what happens with triggers on views & ddl triggers
insert into #sql (sql)
--feedback from ianderson - added code to handle triggers on views
select 'alter table ['+u2.name+'].[' + o2.name + '] disable trigger [' +o1.name+']'
from sysobjects o1
join sysobjects o2
on o1.parent_obj = o2.id
join sysusers u2
on o2.uid = u2.uid
where o1.type = 'TR'
and OBJECTPROPERTY(o1.id,'ExecIsTriggerDisabled')=0
and OBJECTPROPERTY(o2.id, 'IsTable')=1
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.