Compact and repair in SQL server 2000

TampaBay
07-12-2006, 10:04 AM
In MS Access, we can compact and repair the database. How do you do it in MS SQL Server 2000?

Thanks.

00100b
07-12-2006, 10:13 AM
From Enterprise Manager:

Right-click on the Database you wish to shrink
Select "All Tasks"
Select "Shrink Database"


From Transact-SQL:

Use the DBCC SHRINKDATABASE statement

For more information on these methods, see the "Shrinking a Database" topic under "Creating and Maintaining Databases" in MS-SQL Server's Books Online.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum