I have a trigger that was created as an "ALL SERVER" I want to put another trigger in case it gets deleted. however, I am not finding the correct syntax for an ALL SERVER.
CREATE TRIGGER tr_AfterDelete ON [TRIGGERNAME]
AFTER DELETE
AS
The TRIGGERNAME is not right, it isn't dbo. either