Can I revert a transaction after a certain number of days
There isn't anything built into SQL Server that will undo statements. Your options are:


Restore from backup or from database snapshot
Buy a third party development tool like Red Gate's SQL Compare &amp; Data Compare - which may require creating another database, making your changes, and then comparing the differences between them
Buy a log reader tool like Quest Litespeed - which can read Litespeed's transaction log backups and generate undo scripts for specific transactions
Writing your own undo script - whatever changes you plan to make, write the undo scripts yourself to undo your changes