Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jgooch
Starting Member
2 Posts |
 Posted - 2008-06-10 : 11:08:13
|
| *New to SQL Disclaimer* I have two tables in our database that need to be deleted or cleared at certain times of the day. What I've read so far sounds like I need to set up some kind of trigger Delete for the tables, but I'm not entirely sure how to go about it. Any help would be appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-10 : 11:22:10
|
| You need only a SQL job which truncates the table and you need to schedule job to perform according to your required periodicity. refer this as an examplehttp://www.zdnetindia.com/index.php?action=articleDescription&prodid=18039 |
 |
|
|
jgooch
Starting Member
2 Posts |
|
|
|
|
|
Trigger question