I need to setup a SQL script to run nightly. The script starts by creating temp table and it builds up one after the other, and finally dumps the data into a table. The next day it drops the data from the same table, and creates a new data with the same table name. I’m using SQL Server 2005. My question is what would be the best way of achieving this. Please Help. Thanks!
asked May 27 '10 at 08:48 PM in Default
Simply create a SQL Agent job to run the script you have. http://msdn.microsoft.com/en-us/library/ms189237.aspx
answered May 28 '10 at 04:19 AM