Posted by Erland Sommarskog on 02/28/07 22:22

The Man (LeJon7881@gmail.com) writes:
> Does anyone know how to purge old data in a MS SQL server 2000
> database?

I've answered this in another thread, but in just case someone see this:
to be able to delete old data, you need to be able to define what data
that counts as old, and this has to be done per table basis. This is not
something you can do generically. SQL Server does not know itself how
new or old some data is; that information would have to be in the data
itself.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Stored procedure to create a new database with tables
• Prev in forum: Re: millions records archiving and delete
• Thread view: Re: SQL Help with purging old data

[Reply to this message]