Msg 3701, Level 11, State 5, Line 1 Cannot drop the trigger “”, because it does not exist or you do not have permission.

Today I was implementing some triggers, DDL triggers. I created Alter Table trigger on Database; it was working fine. But when I tried to drop it I got error message like”Msg 3701, Level 11, State 5, Line 1 Cannot drop the trigger “”, because it does not exist or you do not have permission. “.

My Trigger:

CREATE TRIGGER TRALTERTABLE ON DATABASE
FOR ALTER_TABLE
AS
SELECT ‘TABLE HAS BEEN ALTERED.’

Drop Trigger:

DROP TRIGGER TRALTERTABLE

Error:

Msg 3701, Level 11, State 5, Line 1
Cannot drop the trigger ‘TRALTERTABLE’, because it does not exist or you do not have permission.

Solution:

If trigger is in Database scope use:

Drop TRIGGER connection_limit_trigger on Database

If trigger is in Server Scope use:

Drop TRIGGER connection_limit_trigger on all server

Advertisements

One thought on “Msg 3701, Level 11, State 5, Line 1 Cannot drop the trigger “”, because it does not exist or you do not have permission.

  1. I actually wanted to send a small note so as to thank you for all the fabulous tips and hints you are showing at this website. My time-consuming internet investigation has at the end been paid with excellent knowledge to write about with my company. I ‘d assume that many of us visitors are very much endowed to exist in a fabulous network with many lovely professionals with interesting hints. I feel rather privileged to have come across the webpage and look forward to really more excellent times reading here. Thank you again for a lot of things.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s