October 20, 2016 at 12:04 am
Comments posted to this topic are about the item Remove the Login Trigger
October 20, 2016 at 4:34 am
The answer is not quite correct. As written, it will run successfully but will not actually drop the trigger.
For logon triggers you need to use:
DROP TRIGGER IF EXISTS CaptureLogins
ON ALL SERVER
GO
-----
JL
October 20, 2016 at 4:47 am
James Lean (10/20/2016)
The answer is not quite correct. As written, it will run successfully but will not actually drop the trigger.For logon triggers you need to use:
DROP TRIGGER IF EXISTS CaptureLoginsON ALL SERVER
GO
+1
ditto in explanation, however thanks Steve for this interesting question.;-)
October 20, 2016 at 5:35 am
George Vobr (10/20/2016)
James Lean (10/20/2016)
The answer is not quite correct. As written, it will run successfully but will not actually drop the trigger.For logon triggers you need to use:
DROP TRIGGER IF EXISTS CaptureLoginsON ALL SERVER
GO
+1
ditto in explanation, however thanks Steve for this interesting question.;-)
I researched it and came up with the same conclusion, so I picked the closest option. It was learning something prompted by the question that I enjoy most, so thanks for a good one. I've never been the biggest fan of triggers in general. Like many things, they have their place, but I don't have to like them. Maybe it's because I've seen them misused and abused too many times over the years. 😉
October 20, 2016 at 11:49 am
corrected.
October 20, 2016 at 12:05 pm
Steve Jones - SSC Editor (10/20/2016)
corrected.
It was still a good question. I like any question where I learn something new.
October 25, 2016 at 2:58 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply