hi there

i am using .net framework 1.1 with SQL 2000 .

i want the data in table to get deleted automatically after 30 days of inserting data.

so how do i achieve this?

 This can be achieved by creating Window Service..

check out for tutorial/help/code > Creating a Windows Service in C#

sample window service to send email on a specific date (with DB interaction) >  Birthday Wish Scheduler in C#

for window service deployment help > Windows Services in Action I

after creating window service you can simply create setup and deployment project to create setup.exe file to be installed at the server side.

let me know if you need further assistance..

hope it helps./. 

thanks for ur reply

i appreciate ur suggestion,but cant this be done without use of windows service .something in the web application itself?

when there is no business logic involved, rather than using web application or windows services it's better to schedule a job in sql server itself.

HTH 

------------------------------------------------------------------------------------------------
Don't forget to click "Mark as Answer" on the post that helped you. 

It depends on how much flexibility/control you have on the database server

DELETE FROM <DBNAME>.<SCHEMANAME>.<TABLENAME>
WHERE DATEDIFF(day,<DATETIMECOLUMNNAME>,GETDATE()) >= 30

You can schedule a job to execute the above t-sql statement once per day every morning [OR] you can execute this as a startup script in your web-application (or whichever the app may be) tied to an even such as first login or session startup or something similar (not ideal though) In case of latter, you better maintain a flag somewhere to check if the statement is ever executed (successfully) for that day.

Regards

Vasu