New system procedures

Table 3-7 summarizes the new system procedures.

Table 3-8: 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.