select a.name,b.name from sysobjects a , sysobjects b where a.id = b.parent_obj and a.xtype = 'u' and b.xtype = 'tr'
或者: select a.name,isnull(b.name,'无触发器') from sysobjects a left outer join sysobjects b on a.id = b.parent_obj and b.xtype = 'tr' where a.xtype = 'u' order by a.name
from sysobjects a , sysobjects b
where a.id = b.parent_obj
and a.xtype = 'u' and b.xtype = 'tr'
select a.name,isnull(b.name,'无触发器')
from sysobjects a left outer join sysobjects b
on a.id = b.parent_obj and b.xtype = 'tr'
where a.xtype = 'u'
order by a.name