Remove the Login Trigger

Question

Post reply

Remove the Login Trigger

Steve Jones - SSC Editor

SSC Guru

Points: 738043
More actions
October 20, 2016 at 12:04 am

#74548

Comments posted to this topic are about the item Remove the Login Trigger

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

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

James Lean SSCertifiable Points: 5757 More actions · Answer 1

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

George Vobr SSChampion Points: 10071 More actions · Answer 2

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 CaptureLogins
ON ALL SERVER
GO

+1

ditto in explanation, however thanks Steve for this interesting question.;-)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

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 CaptureLogins
ON 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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions