Posted by Ed Murphy on 04/05/07 03:41

JA wrote:

> I just deleted about 1 million records from a SQL Server 2000 database. I
> access it using Access 2000.
>
> I have Compact and Repair available in the adp under Tools. Should I do that
> from Access? Will it not mess anything up?

No idea. You can definitely use Query Analyzer to run a
DBCC SHRINKDATABASE command.

If you expect the database to grow back to its previous size and
stay there, then you shouldn't shrink it. If you expect it to
stay at its reduced size, then you should.

[Back to original message]