各位前輩： 一般我們開MS SQL Server中的Trigger需要至Enterprise Manager中的Manager Triggers，且一定要指定要看那一個Table的Trigger，非常不方便，是否有工具可以把某一個Database的所有Trigger及內容列出，這樣才知道這一個Database有多少個Trigger。敬請指教，感激不盡…

------
~小弟淺見，參考看看~

Hi, try this one, select so.name as tri_name, so2.name as table_name, sc.text as tri_content from sysobjects so inner join syscomments sc on so.id=sc.id and so.xtype='TR' inner join sysobjects so2 on so.parent_obj = so2.id

引言: Hi, try this one, select so.name as tri_name, so2.name as table_name, sc.text as tri_content from sysobjects so inner join syscomments sc on so.id=sc.id and so.xtype='TR' inner join sysobjects so2 on so.parent_obj = so2.id

timhuang兄： 可以了…感謝您… 小弟幾乎每次問MS SQL Server的問題您都有辦法解決，真是佩服佩服… 可以允許小弟叫您一聲MS SQL Server God嗎?