compact

[JIMMIE WHITAKER]

No one answered in another group, please help.

Using access 2000 /msde
I know how to compact the access project file (.adp), there's a menu choice
for that.
How do I compact the tables and stored procedures on the server? ( The .MDF
file)
I only have the DOS promp OSQL utility to work with.
thanks

[John Bell]

Hi

There is not a compact command as such in SQL Server. If you want to shrink
the log file check out

Log file filling up
http://www.support.microsoft.com/?id=110139

Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=315512

http://www.mssqlserver.com/faq/logs-shrinklog.asp
Log File Grows too big
http://www.support.microsoft.com/?id=317375
For log file shrinking etc.. check out :

http://msdn.microsoft.com/library/de...r_da2_1uzr.asp

and the following KB articles:

INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default...b;en-us;256650

INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default...b;en-us;272318

Books online will give you all the T-SQL commands

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

or online: such as for DBCC
http://msdn.microsoft.com/library/de...asp?frame=true

You should also look at defragmenting the indexes using either DBCC
DBREINDEX or DBCC INDEXDEFRAG

If you want to read more about SQL Server internals then check out
"Inside SQL Server 2000" by Kalen Delany ISBN 0-7356-0998-5
John

"JIMMIE WHITAKER" <kp*****@worldnet.att.net> wrote in message
news:mZ********************@bgtnsc05-news.ops.worldnet.att.net...

No one answered in another group, please help.

Using access 2000 /msde
I know how to compact the access project file (.adp), there's a menu choice for that.
How do I compact the tables and stored procedures on the server? ( The ..MDF file)
I only have the DOS promp OSQL utility to work with.
thanks