Disabing Trigger on Database

• latheesh.jaya

  Mr or Mrs. 500

  Points: 584

  More actions

  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.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  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.