TR_DATATUNEUP_LIMIT
Definition
Copy
CREATE trigger TR_DATATUNEUP_LIMIT on dbo.DATATUNEUP after insert
as begin
begin try
if (select count(ID) from dbo.DATATUNEUP) > 1
begin
raiserror('BBERR_DATATUNEUP_ROWEXISTS : Data tune-up settings already exists.', 13, 1);
end
end try
begin catch
exec dbo.USP_RAISE_ERROR;
rollback tran;
end catch
end