System Stored Procedures

Adaptive Server 15.7, ESD #2 contains new and changed system procedures.

New System Stored Procedures
System Stored Procedures Description
sp_config_dump Allows you to list, add, or change dump configurations.
sp_dump_history Allows you to purge dump records from the dump history file. The original dump history file is saved with the timestamp suffixed to the file name.
sp_optgoal 'show','goal_name' Reports all individual criteria activated by the user-created optimizer goal.
sp_restore_system_role Restores the system-defined roles or database owner privileges to the system defaults.
sp_shmdumpconfig Configures shared memory dumps.

Changed System Stored Procedures
System Stored Procedures Description
sp_dboption Adds the deferred table allocation parameter to configure the database so Adaptive Server defers page allocation for all subsequently created user tables.
sp_checksource Allows you to include a predicated privilege for objname
sp_hidetext Allows you to include a predicated privilege for objname
These system procedures display information about predicated privileges:
  • sp_helprotect
  • sp_help
  • sp_helptext
  • sp_checksource
These system procedures display information about granular permissions:
  • sp_help
  • sp_helprotect

See the Reference Manual: Procedures.