Q:

ASP.NET Update database every hour

I want to copy one row from table A to table B per hour on my asp.net website. How can I do that? Do I need win32 application? I would like to avoid that.

A:

This sounds like you want to create a stored procedure and use the Sql Server Jobs scheduler to run it every hour.  See here for details of setting that up
Or if you are using Sql Express see this question "How to run a stored procedure every day in SQL Server Express Edition?"
Ideally you wouldn't do this using IIS etc, unless there is some reason you don't have access to the database.

