Inserting data into a second table with some time lag I am new to SQL Server. I am using Management studio 2012 Express edition.

What I want to do is that suppose I have table1 and table2 and suppose someone enters some data into table1, then after some time lag the data must be entered automatically into table2.

I remembered reading about scheduled events, but realized that the express edition does not support Server Agent.

Any suggestions as to how I could tackle this problem?

Thank you :)
Given the constraints of Express (http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx), your best option is to fake an agent job by using Windows Scheduled Tasks and call SQLCMD on a stored procedure every n units of time.  Here is a basic SQLCMD usage rundown: http://msdn.microsoft.com/en-us/library/ms180944.aspx.