Post reply

Disabing Trigger on Database

  • August 18, 2008 at 1:32 am

    #75284

    How can I disable all triggers in my database?

    I used the following code for the same.

    USE

    Disable Trigger ALL On

    But its showing the following error:

    Msg 1088, Level 16, State 21, Line 1

    Cannot find the object "NAWINMLT004.dbo.OLTP" because it does not exist or you do not have permissions.

    I would appreciate some one help me on this.

  • August 18, 2008 at 1:14 pm

    #859622

    The error message described clearly. The most often mistake is the owner of object is not dbo but under a user name. Please check.

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

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