Table which will become blank after a certain period.

[RajpootRohan]

Hi , I have a application in which I have to store the user's data.So that he can retrieve it between its visits to the website.But I want that after 30 days that table should become blank. Is there any way out. Please give some guidance.... Thanx in advance.

cheers, sneha

[J4amieC]

On SQL Server, this is generally achieved by using a SQL Agent that periodically scans the table for records older than "x" and removes them.

[RajpootRohan]

Thanks a lot... It really worked...

cheers, sneha

[Senthil_M]

Sneha, Pls give a brief about how did you do it? Senthil

[ashok_rgm]

Hello mate, Is it not going to effect your applications which are using the data from those tables, here I have similar problem like how to identify the unaccessed tables over a period of time. Can u pls help me out, Regards, Ashok

ashok