Table 3-7 summarizes the new system procedures.
Procedure |
Change |
---|---|
sp_helptext |
Displays the source text of a compiled object. |
sp_tempdb |
Creates the default temporary database group and binds temporary databases to the default temporary database group. |
sp_dbcc_recommendations |
Analyzes faults reported by the checkstorage operation and summarizes them. |
sp_dbcc_help_fault |
Provides a description of the specified fault type and the recommended fix. |
sp_dbcc_exclusions |
Allows the user to create and manage persistent exclusion lists for use by checkverify and sp_dbcc_faultreport. |