Ch10 - issue with insert in log table
Because of the ROLLBACK in here
IF DATEPART(hh,GETDATE()) > 7 AND DATEPART(hh,GETDATE()) < 20
BEGIN
RAISERROR ('You can only perform this change between 8PM and 7AM. Please try this change again or contact Production support for an override.', 16, -1)
ROLLBACK
END
The insert into the log table gets also rollbacked
|