A while back it was suggested that I delete the journals in order to speed things up/make more space. I have searched and can't seem to find any information on how to do this. Do I need to run an sql or is there simply something ro run on RMS?
Thanks for the help.
coupleofdogs
Actually, journals cosume a big amount of space in the database, u can schedule a job to delete journals older than 1 or 2 moths (based on what the finance department will accept)
just create a new job, schedule it to run on daily basis to remove journals older than a month, add the following statement in the only step in the job
************************* DELETE Journal WHERE Time < getdate() - 30 *************************
What about a simple way to archive them without an add-in? Any possibilities?
How are they stored in the database?
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.