add a column in table where you want to copy data with default value of getdate.
so when every you insert data into table timestamp column took the insertion time automatically
Rohit Garg (My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.
Proposed as answer byOlaf HelperMVPWednesday, September 25, 2013 5:56 PM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.