sp_drop_time

Syntax

sp_drop_time_range name

Example 1 – Removes the “evenings” time range:
```
sp_drop_time_range evenings
```

There are additional considerations when using sp_drop_time_range:

You cannot remove the “at all times” time range.
You cannot drop a time range if a resource limit exists for that time range.
Dropping a time range does not affect the active time ranges for sessions currently in progress.

For more information on time ranges, see the System Administration Guide.

The permission checks for sp_drop_time_range differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage resource limit` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role.

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect