Stop een database trigger met de custom check in de database, de error die hierin wordt geraised zal netjes getoond worden in alle applicaties.

Voorbeeld:

CREATE TRIGGER [Member].[TRMEMBERSET_CHECK_RESERVATION] ON [Member].[STMEMBERSET] FOR INSERT AS DECLARE @member_id int DECLARE @count_reserverations int DECLARE @seq int DECLARE @reservation_date datetime DECLARE @settype int BEGIN select @member_id = member_id from inserted select @seq = set_sequence_no from inserted select @settype = log_type from inserted select @reservation_date = b.start_date from inserted a, planner.stcalendar b where a.cal_id = b.cal_id IF convert(datetime, floor(convert(float, @reservation_date))) ⇐ convert(datetime, floor(convert(float, getdate()))) AND @settype <> 0 BEGIN RAISERROR ('Niet toegelaten van te reserveren op de dag zelf.', 16, 1) DELETE from member.stmemberset where set_sequence_no = @seq RETURN END END