When you enable trace flag 828 on a computer that is running Microsoft SQL Server 2000 Service Pack 4 (SP4), checkpoint resumes the behavior that it exhibited before you installed SQL Server 2000 SP3.
Read More - Register for Free Membership
