Fog Creek Software
Discussion Board




Closed Item Purge

Is there a closed item purge period?

Fred Schetterer
Sunday, March 23, 2003

Only for inquires that are closed or marked as SPAM.  Not for normal bugs or features.

Michael H. Pryor
Monday, March 24, 2003

What's the best way to purge arbitrary bugs that we don't want to see at all any more?

Is it safe to do something in the database (we use SQL Server).

Thanks!

Stewart Buskirk
Friday, March 28, 2003

You could do this

DELETE FROM BUGEVENT where ixBug = x
DELETE FROM BUG where ixBug = x

Better make a backup before you do something like that though :)

Michael H. Pryor
Friday, March 28, 2003

Yes, thanks already added two Stored Procedures.
One that cleans up attachments when the Bug closes and another that cleans up Bugs closed for one year. Then add a Job for each under SQL Server Agent Management.

Fred Schetterer
Sunday, March 30, 2003

*  Recent Topics

*  Fog Creek Home