Removes a user-defined time range from Adaptive Server.
sp_drop_time_range name
is the name of the time range to be dropped.
Removes the “evenings” time range:
sp_drop_time_range evenings
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.
The permission checks for sp_drop_time_range differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage resource limit privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
Documents For more information on time ranges, see the System Administration Guide.
System procedures sp_add_resource_limit, sp_add_time_range, sp_modify_time_range
