Post reply

Deleting triggers

  • May 23, 2005 at 9:24 am

    #86551

    Hi all,

    I am having a problem deleting a trigger from a table.

    I had some triggers on various tables in my database, i have easily been able to delete the other triggers but this one just hangs the EM when I say Yes I am sure I want to delete it. I don't think I can take the databse offline because it is in constant use, can anyone help

     

    Thanks

     

    Fred

  • May 24, 2005 at 8:17 am

    #560764

    Fred,

    You might try using the DROP TRIGGER statement in Query Analyzer. It's a little more efficient than using Enterprise Manager and much less prone to hanging on a busy server.

    More details can be found in Books Online under the DROP TRIGGER topic.

    -- J.Kozloski, MCDBA, MCITP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply