sp_drop_time_range

Removes a user-defined time range from the SAP ASE server.

Syntax

sp_drop_time_range name

Parameters

Examples

Usage

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.

Permissions

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

SettingDescription
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.

Auditing

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

InformationValues
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

Related reference
sp_add_resource_limit
sp_add_time_range
sp_modify_time_range