System Stored Procedures

Adaptive Server 15.7 SP100 contains new and changed system stored procedures.

New System Stored Procedures
System Stored Procedures	Description
sp_helpdefrag	Reports defragmentation information for either all eligible objects for reorg defrag in the database from which the command is invoked from or for the given object if it is eligible for reorg defrag.
sp_dump_info	sp_dump_info displays the size of data and log that a cumulative dump would contain at a specific point in time.

Changed System Stored Procedures
System Stored Procedures	Description
sp_configure	Enable concurrent transaction dumps and cumulative database dumps by setting the enable concurrent dump tran parameter to 1. Enables the gathering of index attributes using hash-based statistics when creating an index by including the utility statistics hashing parameter.
sp_config_rep_agent	Supports the additional distribution model filter for the multipath distribution model property.
sp_dboption	Includes the allow incremental dumps parameter which supports the backup and restoration of cumulative dumps.
sp_depends	Displays additional information about precomputed result sets.
sp_dump_history	Supports the same functionality for cumulative dumps as for full database dumps when you specify the cumulative keyword in the `@dump_type` parameter.
sp_extrapwdchecks	Supports NULL values for caller_password and loginame parameters.
sp_helpdb	Output includes information about the durability of a user-created temporary database.
sp_helprotect	Includes the owner name in the `object` column for objects (tables, databases, and so on).
sp_listener	Adds support for the AF_UNIX protocol.
sp_optgoal	When granular permissions is enabled you must be a user with `manage opt goal` to create or delete a goal.
sp_replication_path	Supports binding, unbinding, and listing of filters.
sp_showoptstats	Displays additional information about precomputed result sets.
sp_sjobcreate	Includes the continuous_run parameter, which allows you to execute jobs from a starting time and run them according to specified intervals until an end time.
sp_sjobmodify	Includes the continuous_run parameter, which allows you to execute jobs from a starting time and run them according to specified intervals until an end time.