Use sp_drop_time_range to drop a user-defined time range.
See sp_drop_time_range in the Reference Manual: Procedures.
For example, to remove the evenings time range from the systimeranges system table in the master database, enter:
sp_drop_time_range evenings
You cannot drop the “at all times” time
range or any time range for which resource limits are defined.
