TampaBay

In MS Access, we can compact and repair the database. How do you do it in MS SQL Server 2000?

Thanks.

00100b

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.