Home Dashboard Directory Help
Search

ALTER TRIGGER implicitly enables a disabled trigger by ta.speot.is


Status: 

Resolved
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 781722
Opened: 3/19/2013 8:44:13 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

From observation, running ALTER TRIGGER on a disabled trigger will enable it.

I consider it incorrect behaviour, but please keep in mind that if it is intended behaviour that:

* ALTER TRIGGER's documentation says that it "Modifies the definition of a ... trigger".
* The documentation does not explicitly state what the "definition" consists of.
* The documentation does not explicitly state that ALTER TRIGGER will enable a disabled trigger.
Details
Sign in to post a comment.
Posted by Tom.Thomson on 9/10/2013 at 4:59 AM
I wonder how long "a couple of weeks" is going to be. Twelve weeks already feels like rather more than "a couple".
Posted by Microsoft on 6/19/2013 at 1:43 PM
Added to the remarks, that changing the trigger using ALTER TRIGGER enables the trigger. It will take a couple weeks for the change to appear online. Thank you for reporting this.
Posted by EdSF1 on 6/6/2013 at 1:00 PM
Please do add to documentation - I'm another one of those "huh"? folk:
http://stackoverflow.com/q/16969554/304683

Thank you.
Posted by Microsoft on 5/3/2013 at 12:05 PM
Hello,
The behavior you are seeing is by design. We will document it in Books Online. Thanks for reporting this.

--
Umachandar, SQL Programmability Team
Sign in to post a workaround.