TR_DATABASEMAILSETTINGS_LIMIT (Trigger)

                
CREATE trigger TR_DATABASEMAILSETTINGS_LIMIT on dbo.DATABASEMAILSETTINGS after insert
as begin
    if (select count(ID) from dbo.DATABASEMAILSETTINGS) > 1
    begin
        exec dbo.USP_RAISE_ERROR
        rollback tran
    end
end