PurgeHistory Method

SQLServer Object

Description

Removes information from the task history log. Set the properties of a created HistoryFilter object as desired and pass it to the PurgeHistory method.

Visual Basic

SQLServer.PurgeHistory ( [[HistoryFilter :=] HistoryFilter] )

C++

HRESULT pSQLServer->PurgeHistory ( LPSQLOLEHISTORYFILTER HistoryFilter = NULL );

Elements

Element Type Description

HistoryFilter HistoryFilter HistoryFilter object

Remarks

Only the system administrator can purge history information for tasks owned by other users.

Reference

sp_purgehistory