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