New and changed system procedures

Table 3-7 summarizes the changes made to existing system procedures.

**Table 3-7: Changed system procedures**
Procedure	Change
sp_monitorconfig	Adaptive Server 12.5.0.3 adds the all parameter, which displays descriptor help information for all 34 indexes, objects, databases, and auxiliary scan descriptors in the server.
sp_dboption	Adds the async log service option, which enables, disables, or configures the asynchronous log service feature. Can prevent user-created temporary databases from being set to single-user mode.
sp_helpdb	Adds a column to display asynchronous log service information. Reports whether or not a database is a user-created temporary database in the status column.
sp_help	Adds a column that displays optimistic index lock information.
sp_chgattribute	Adds the optimistic_index_lock option, which acquires an optimistic index lock on a table.
sp_bindcache	Can precent bvinding of individual tables to a named cache in user-created temporary databases.
sp_dbcc_summary_report	Adds the display_recommendations parameter, which enables reporting the recommendations generated by sp_dbcc_recommandations.
sp_dbcc_faultreport	Displays faults in ordered list by table and index. Adds these new parameters: exclusion_mode – ignores or applies exclusion lists. exclusion_faults – list of fault types to be excluded from reporting. exclusion_tables – list of tables to be excluded from reporting. exclusion_combo – list of fault/table combinations to be excluded from reporting. display_recommendations – enables reporting the recommendations generated by sp_dbcc_recommendations.
sp_dbcc_checkverify	Adds these new parameters: *ignore_exclusions* – enables or disables the exclusion list. *tblename* – limits checkverify processing to a specific .object.
sp_dbcc_updateconfig	Provides default configuration values for dbcc configuration values. Accepts delete as a value for the str1 parameter. Disables enable automatic workspace expansion for databases that are enabled by default.
sp_dbcc_configreport	Adds the defaults parameter, which enables only the display of configured default values.