How to find triggers in a sql server 7 ?

Hello there
Before this weekend I wrote a trigger on a sql 7 DB and sadly enough I
didn't wrote it in the DB documentation.
So now i am standing in front of SQL 7 user DB and want to modify it and
have no idea what the name of it is and how to access it or anything ?
what do I do to find it ? (I used informationschema and it doesn't have
any trigger options in it...) how do I find all triggers in a sql 7 user
db ? how to modify it ?
please help !Schema: How do I show all the triggers in a database?
http://www.aspfaq.com/show.asp?id=2105
AMB
"Simo Sentissi" wrote:
> Hello there
> Before this weekend I wrote a trigger on a sql 7 DB and sadly enough I
> didn't wrote it in the DB documentation.
> So now i am standing in front of SQL 7 user DB and want to modify it and
> have no idea what the name of it is and how to access it or anything ?
> what do I do to find it ? (I used informationschema and it doesn't have
> any trigger options in it...) how do I find all triggers in a sql 7 user
> db ? how to modify it ?
> please help !
>|||"Simo Sentissi" <simo@.sentissiweb.com> wrote in message
news:eg4ienzyEHA.2572@.tk2msftngp13.phx.gbl...
> Hello there
> Before this weekend I wrote a trigger on a sql 7 DB and sadly enough I
> didn't wrote it in the DB documentation.
> So now i am standing in front of SQL 7 user DB and want to modify it and
> have no idea what the name of it is and how to access it or anything ?
> what do I do to find it ? (I used informationschema and it doesn't have
> any trigger options in it...) how do I find all triggers in a sql 7 user
> db ? how to modify it ?
> please help !
SELECT * FROM sysobjects WHERE TYPE = 'TR'
This will give you a list of triggers.
For each trigger row returned, you can find out which table it is attached
to by running the following query and using the parent_obj ID value from the
list of triggers returned.
SELECT * FROM sysobjects WHERE ID = <parent_obj>
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||select *
from sysobjects
where type = 'TR'
You modify the trigger using alter trigger. See books online
topic Alter Trigger for more information.
-Sue
On Mon, 15 Nov 2004 10:37:53 -0700, Simo Sentissi
<simo@.sentissiweb.com> wrote:
>Hello there
>Before this weekend I wrote a trigger on a sql 7 DB and sadly enough I
>didn't wrote it in the DB documentation.
>So now i am standing in front of SQL 7 user DB and want to modify it and
>have no idea what the name of it is and how to access it or anything ?
>what do I do to find it ? (I used informationschema and it doesn't have
>any trigger options in it...) how do I find all triggers in a sql 7 user
>db ? how to modify it ?
>please help !sql