Massive DUMP!

[jesus4u]

Ok, what is the best practice to empty out a table at the end of the month of all records? IS there a trigger that can do it for me or what?

Thanks

[Cander]

i do believe you can scehdule a stored procedure to run monthly in SQL. Just use Delete From tablename
look in Enterprise manager


computename -> Management -> Jobs

[jesus4u]

thanks I see it

[Mc Brain]

Or you can use: "TRUNCATE TABLE tablename", instead.