Results 1 to 4 of 4

Thread: Disable trigger

  1. #1
    Join Date
    Mar 2004
    Location
    China SHANGHAI
    Posts
    7

    Unanswered: Disable trigger

    Sorry, may be it is very simple, but
    how can I disable all trigger on a tabled under sql 2000

  2. #2
    Join Date
    Mar 2004
    Location
    China SHANGHAI
    Posts
    7

    Re: Disable trigger

    Originally posted by xiangmeihong
    Sorry, may be it is very simple, but
    how can I disable all trigger on a tabled under sql 2000
    sorry
    how can I disable all trigger on a table under sql 2000

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    REfer books online for ALTER TABLE syntax to disable/enable trigger as specified.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Mar 2004
    Location
    China SHANGHAI
    Posts
    7
    Originally posted by Satya
    REfer books online for ALTER TABLE syntax to disable/enable trigger as specified.
    THANK YOU!

Posting Permissions

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