Click here to Skip to main content
15,791,963 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to create a table in microsoft sql which is drop after 24 hours automatically
Ron Beyer 14-Jan-14 1:00am    
You could create a batch script and use task scheduler to run it every 24 hours, I'm not sure if SQL server has any kind of job system that can run SQL scripts on a schedule...

1 solution

SQL Server Agent[^] will probably be your best bet
Share this answer
Ron Beyer 14-Jan-14 1:02am    

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900