MSDE : find out what triggers are created

Hi
may i know is there anyway for me to find out from any system table in
MSDE what are the triggers that have been created ?
I wish to delete all and log in a new set of triggers, just in case
some old triggers cause some problems to the new ones.
Thank you
Best regards
Boon Yiang
Hi,
From OSQL Query the SYSOBJECTS table.
use <dbname>
go
Select name from sysobjects where xtype = 'tr'
Thanks
Hari
<chuaby@.hotmail.com> wrote in message
news:1174143091.658347.48080@.e65g2000hsc.googlegro ups.com...
> Hi
> may i know is there anyway for me to find out from any system table in
> MSDE what are the triggers that have been created ?
> I wish to delete all and log in a new set of triggers, just in case
> some old triggers cause some problems to the new ones.
> Thank you
> Best regards
> Boon Yiang
>