Dropping a Named Time Range

Use sp_drop_time_range to drop a user-defined time range.

Note: You cannot drop the “at all times” time range or any time range for which resource limits are defined.
To remove the evenings time range from the systimeranges system table in the master database, enter:
sp_drop_time_range evenings

See sp_drop_time_range in the Reference Manual: Procedures.