I am new to this forum.
I am using MS SQL 2005 Express
I have a database GK.dbo (the original databese) and I have created a database GK_2009.dbo (it is created from the original database, so it has the same structure)
I want to create a script that would copy a table from GK database to GK_2009 database and after the copying is finished and verified, the data from the table in the GK database, must be deleted (only data, and not the table). I need it for the scheduled data copying, and I will use Windows Scheduled task. is it possible to do it? how can I do it?