Professional Web Applications Themes

desactivate trigger - Microsoft SQL / MS SQL Server

Hi I want desactivate trigger without drop it do you know a command to do that thanks...

  1. #1

    Default desactivate trigger

    Hi

    I want desactivate trigger without drop it

    do you know a command to do that
    thanks
    rl Guest

  2. #2

    Default Re: desactivate trigger

    ALTER TABLE <table name> DISABLE TRIGGER <trigger name>

    Or to disable all triggers:
    ALTER TABLE <table name> DISABLE TRIGGER ALL

    Enable them again:
    ALTER TABLE <table name> ENABLE TRIGGER <trigger name>
    ALTER TABLE <table name> ENABLE TRIGGER ALL
    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "rl" <com> wrote in message
    news:091601c34ac8$bd3975c0$gbl... 


    Jacco Guest

  3. #3

    Default Re: desactivate trigger

    alter table <table> disable trigger <trigger name>

    --
    -Vishal
    "rl" <com> wrote in message
    news:091601c34ac8$bd3975c0$gbl... 


    Vishal Guest

Similar Threads

  1. XML.TRIGGER
    By Dan-C in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: February 28th, 03:55 PM
  2. Events don't trigger
    By ss yy via .NET 247 in forum ASP.NET Web Services
    Replies: 0
    Last Post: August 30th, 12:11 AM
  3. Trigger
    By James in forum ASP Database
    Replies: 1
    Last Post: August 6th, 01:05 AM
  4. Trigger Help
    By Mike in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 9th, 07:28 PM
  5. Trigger key
    By Elisabeth Smith in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 2nd, 09:22 AM

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