Professional Web Applications Themes

Diabled Triggers - Microsoft SQL / MS SQL Server

Is there any way, I can get the list of all Disabled triggers from a particular databse. I need it urgently plz Babu...

Sponsored Links
  1. #1

    Default Diabled Triggers

    Is there any way, I can get the list of all Disabled
    triggers from a particular databse.

    I need it urgently plz

    Babu



    Sponsored Links
    BAbu Guest

  2. #2

    Default Re: Diabled Triggers

    select name
    from sysobjects
    where type='tr'
    and objectproperty(id,'ExecIsTriggerDisabled')=1

    --
    -oj
    RAC v2.2 & QALite!
    [url]http://www.rac4sql.net[/url]



    "BAbu" <gaj_babuhotmail.com> wrote in message
    news:010701c348a8$d6b30d30$a301280aphx.gbl...
    > Is there any way, I can get the list of all Disabled
    > triggers from a particular databse.
    >
    > I need it urgently plz
    >
    > Babu
    >
    >
    >

    oj Guest

  3. #3

    Default Re: Diabled Triggers

    HI Oj,

    Thanks a lot for your help, It worked

    Babu
    >-----Original Message-----
    >select name
    >from sysobjects
    >where type='tr'
    >and objectproperty(id,'ExecIsTriggerDisabled')=1
    >
    >--
    >-oj
    >RAC v2.2 & QALite!
    >[url]http://www.rac4sql.net[/url]
    >
    >
    >
    >"BAbu" <gaj_babuhotmail.com> wrote in message
    >news:010701c348a8$d6b30d30$a301280aphx.gbl...
    >> Is there any way, I can get the list of all Disabled
    >> triggers from a particular databse.
    >>
    >> I need it urgently plz
    >>
    >> Babu
    >>
    >>
    >>
    >
    >
    >.
    >
    Babu Guest

Similar Threads

  1. triggers in DB2
    By Piotr in forum IBM DB2
    Replies: 2
    Last Post: August 27th, 03:37 PM
  2. Triggers
    By P. Saint-Jacques in forum IBM DB2
    Replies: 0
    Last Post: August 8th, 02:30 AM
  3. Help with triggers
    By W Gemini in forum IBM DB2
    Replies: 0
    Last Post: August 7th, 11:45 AM
  4. Are Cursors in Triggers really bad?
    By George Wynne in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 1st, 03:50 PM
  5. viewing triggers?
    By Adria in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: June 30th, 05:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139