October 12, 2005 at 3:06 pm
I assume a trigger is the easiest way to do this. I would like to take all records from one table and move them to another table if they are over a year old. Suggestions?
October 12, 2005 at 3:09 pm
I do not see how a Trigger would be fired for records such as this..., I am assuming these are 'old' records which would probably not be accessed, hence a Trigger would not fire.
Write a stored procedured that is scheduled to run every night or once a week or whenever you find this appropriate...
I wasn't born stupid - I had to study.
October 13, 2005 at 6:35 am
...or a DTS job. Either way depending on what tools you know.
October 13, 2005 at 9:19 am
You definitely want a scheduled job of some kind to do this. A trigger would fire every time someone did an insert or update or delete depending on how you set up the trigger. A scheduled job is better, you can pick a low utilization period to run the job and not impact your users.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy