After purging in MS-Sql......

[DBergkamp10]

Do I need to rebuild like in Pervasive?

Also, I used to simply initilise OEHDRAUD and OELINAUD? Still doable?

THX in advance!

 

[DBergkamp10]

TO clarify - I am purging by traditional means like Inv Trx Hist by item report, not thru queries.

 

[dgillz]

I'm confused, did you initialize the tables or purge them?

In either case, the answer is no, the .mdf file will shrink automatically. You need to make you periodically shrink your log files (.ldf) or they will grow forever. I do this with a database maintenance plan.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[DBergkamp10]

Hey Don,

Back in the progression days I would simply initialize my OEHDRAUD AND LINAUD tables rather than purge them, after taking a copy of course.

Regards,

I