SQLServer Object
Removes information from the task history log. Set the properties of a created HistoryFilter object as desired and pass it to the PurgeHistory method.
SQLServer.PurgeHistory ( [[HistoryFilter :=] HistoryFilter] )
HRESULT pSQLServer->PurgeHistory ( LPSQLOLEHISTORYFILTER HistoryFilter = NULL );
Element | Type | Description |
---|
HistoryFilter | HistoryFilter | HistoryFilter object |
Only the system administrator can purge history information for tasks owned by other users.
sp_purgehistory