Use sp_drop_time_range to drop a user-defined time range
For syntax and detailed information, see sp_drop_time_range in the Reference Manual.
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.
