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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-28 : 23:55:33
|
Gregor writes "Hi there
I was interested in your opinion on the follwoing scenario which I have.
We have an audit_trail table which audits delas during the day - it will be updated every 15 seconds perhaps, so at the end of the day (say 6pm or whatever) I need to keep this data and archive it somewhere. By archiving in this scenario I mean taking the data out of the table and storing it so the audit table is therefore blank ready for the next day.
What is the safest way to do this ?
and what would be the most efficient way of doing it (i.e. dts or whatnot)
Any suggestions welcome please and thankyou for any help you can give me.
Regards
Gregor" |
|
|
|
|
|
Auditing a table every night