System Stored Procedures

New and changed system stored procedures in Adaptive Server 15.0

New stored procedures

Stored procedure

Function

sp_helpcomputedcolumn

Reports information on all the computed columns in a specified table

sp_version

Returns the version information of the installation scripts (installmaster, installdbccdb, and so on) that was last run and whether it was successful.

Changed system stored procedures

Stored procedure

Change

sp_checksource

Checks the existence of computed columns source text.

sp_help

Reports information on computed columns, function-based indexes, and partitions.

sp_helpartion

Adds detailed partition information to its output.

sp_helpindex

Reports information on computed column indexes, function-based indexes, and partitions.

sp_helptext

Displays the source text of computed columns, function-based index definitions, and partitions.

sp_hidetext

Hides the text of computed columns, function-based index keys, and partition condition.

sp_modifylogin

Adds option "enable logins during recovery".

sp_webservices

Adds addalias, deploy, dropalias, listudws, listalias, and undeploy options to support user-defined Web Services.

sp_monitorconfig

Supports the number of open partitions configuration parameter.

sp_countmetadata

Supports the number of open partitions configuration parameter.

sp_helpsegment

Prints segment bindings for objects and partitions.

sp_objectsegment

Displays segment information for all partitions for an object.

sp_placeobject

Enables future allocations for a partition from a new segment.

sp_dbcc_faultreport

Creates reports for a specific OPID or fault type.

sp_sysmon

Reports information related to open partitions Metadata Cache Management section of the configuration file.

See the Reference Manual: Procedures.