Massive DUMP!

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

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

thanks I see it

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