deleting journals

hi dexter, you can run this in query and delete the data per your interest: delete from journal where [time] My data base is approaching 2gb. I want to delete some journals. i know i

Thanks alot. I will try it.

"Akber Alwani" wrote:

Thanks alot. I will try it.

"Akber Alwani" wrote:

i tried the script but the results were- no records were affected. I am trying to delete journals that are earlier than 01-01-2006. Please can u give the exact wording of the script.

help

"dexter" wrote:

They did under the "database size" thread.

DELETE StoreOps.dbo.Journal where time < getdate()-60 (60 is the number of days to keep receipts)

Mickie

dexter wrote:

I meant that it appears that the journals were not deleted.

"dexter" wrote:

Dexter,

The commands given will not delete all of the Journals, just the ones before the date you typed in.

As Akber posted, the following will delete all receipts journals before and including Jan 1, 2007.

DELETE from Journal WHERE [Time]

Jeff My mistake. I was confusing batches with Journals (receipts). I just confirmed that i have only journals from the

02/26/07 to present. Four months of journals should take up 1606.54 mb of space (1719mb-112.46mb)

Now, how do i check to see what is my actual data base size so that i may shr> Dexter,

Thanks Jeff. I will be out for two weeks. i will give u some feed back when i return

Thanks again.

"Jeff @ Check Po> Dexter,

Jeff, will this work with POS 2.0? thx.

This does not seem to work on RMS 2.0

i get this bert error

An error occurred while executing query:

Invalid object name 'StoreOps.dbo.Journal'.

RO"Mr.J" wrote: