TR_DATABASEMAILSETTINGS_LIMIT

Definition

Copy


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