System Stored Procedures

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.

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.