find out tirggers in a DB

Hi,
I've a DB not designed by me. I found that there is a trigger updating
table B when I update table A. I want to disable this trigger but I
don't know the name. Can someone help me? Thanks.
See if this helps you
http://dimantdatabasesolutions.blogspot.com/2007/04/has-table-trigger.html
"klonic" <jaume.pf@.gmail.com> wrote in message
news:1181202534.816813.51310@.m36g2000hse.googlegro ups.com...
> Hi,
> I've a DB not designed by me. I found that there is a trigger updating
> table B when I update table A. I want to disable this trigger but I
> don't know the name. Can someone help me? Thanks.
>
|||Thanks for your help. I found the trigger I was looking for!!! It's
possible to know the code of the trigger?
On Jun 7, 10:04 am, "vt" <vinu.t.1...@.gmail.com> wrote:
> Hi
> Hope you using sql 2000
> SELECT
> name,
> status = CASE WHEN OBJECTPROPERTY (id, 'ExecIsTriggerDisabled') = 0
> THEN 'Enabled' ELSE 'Disabled' END,
> Table_name = OBJECT_NAME (parent_obj)
> FROM
> sysobjects
> WHERE
> type = 'TR'
> the above select returns all the triggers in the database.
> then use the ALTER TABLE to disable the trigger
> --
> VT
> Knowledge is power, share it...http://oneplace4sql.blogspot.com/"klonic" <jaume...@.gmail.com> wrote in message
> news:1181202534.816813.51310@.m36g2000hse.googlegro ups.com...
>
>
> - Show quoted text -
|||On Jun 7, 1:47 pm, "vt" <vinu.t.1...@.gmail.com> wrote:
> Hi
> sp_helptext triggername
> See bol for more info
> regards
> VT
> Knowledge is power, share it...http://oneplace4sql.blogspot.com/"klonic" <jaume...@.gmail.com> wrote in message
> news:1181205063.304596.159350@.p47g2000hsd.googlegr oups.com...
>
>
>
>
>
>
> - Show quoted text -
select object_definition(object_id(<trigger name>))
sp_helptext <table name>
select definition from sys.sql_modules where object_id =
object_id(<trigger name>)
|||Thanks to everybody for your help! With your posts and some
imagination i solved out the problem!
C U!
On Jun 7, 4:52 pm, amish <shahami...@.gmail.com> wrote:
> On Jun 7, 1:47 pm, "vt" <vinu.t.1...@.gmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
> select object_definition(object_id(<trigger name>))
> sp_helptext <table name>
> select definition from sys.sql_modules where object_id =
> object_id(<trigger name>)- Hide quoted text -
> - Show quoted text -