I would like to know a way to create a
trigger in sql-server to restrict the time of manipulation of a table between two hours (8:00 to 18:00) of working days.
Yes, it's possible. Below is code that does this, taken from Limit user access to a certain time .
CREATE TRIGGER usrLoginCheck_LogonTrigger ON ALL SERVER WITH EXECUTE AS 'batchid' FOR LOGON AS BEGIN declare @EarlyTime datetime, @LateTime datetime, @todays_date varchar(25) set @todays_date = CONVERT(varCHAR(25),GETDATE(),110) set @EarlyTime = Convert(datetime, @todays_date + ' 07:00:00.000') set @LateTime = Convert(datetime, @todays_date + ' 23:00:00.000') if ORIGINAL_LOGIN()= 'batchid' and getdate() between @EarlyTime and @LateTime ROLLBACK; END