Deletes the results of dbcc checkstorage operations performed on the target database before the specified date and time.
sp_dbcc_deletehistory [cutoffdate [, dbname]]
deletes all entries made on or before this date. This parameter is of type datetime. If a date is not specified, only the results of the last operation are retained. For more information, see “Specifying the date”.
specifies the name of the database for which the data must be deleted. If not specified, sp_dbcc_deletehistory deletes the history information for all databases in dbccdb..dbcc_config.
Deletes results of all operations performed on the database pubs2 on or before March 4, 1997:
sp_dbcc_deletehistory "03/04/1997", "pubs2"
sp_dbcc_deletehistory deletes the results of dbcc checkstorage operations performed on the target database before the specified date and time.
If the target database is dbccdb, and the dbccalt database exists, sp_dbcc_deletehistory deletes historical data for dbccdb from dbccalt.
The value specified for cutoffdate is compared to the finish time of each dbcc operation.
To see the dates when dbcc checkstorage was run so that you can choose the value for cutoffdate, run sp_dbcc_summaryreport.
See the System Administration Guide for information on the dbccalt database.
Only a System Administrator or the Database Owner can run sp_dbcc_deletehistory on a specific database. Only a System Administrator can run sp_dbcc_deletehistory without specifying a database name.
Commands dbcc
dbcc stored procedures sp_dbcc_deletedb, sp_dbcc_evaluatedb
System procedures sp_plan_dbccdb
