sp_purgehistory

Transact-SQL Reference

Transact-SQL Reference

sp_purgehistory

sp_purgehistory is provided for backward compatibility only. For more information about the replacement procedures for Microsoft® SQL Server™ 2000, see SQL Server Backward Compatibility Details.

Removes information from the history log.

Important  For more information about syntax used in earlier versions of SQL Server, see the Microsoft SQL Server Transact-SQL Reference for version 6.x.

Remarks

For task management, use SQL Server Enterprise Manager.

Permissions

Execute permissions default to the public role.

See Also

sp_addtask

sp_helphistory

System Stored Procedures