Table 2-9: Changed system procedures
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.
|