Question of the Day

Trigger Order III

I have created these triggers in SQL Server 2022:

CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT
AS
PRINT 'one'
GO
CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT
AS
PRINT 'two'
GO

I want to be sure that the trigger with "1" runs first. I decide to run this:

EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'

What happens?

See possible answers