TampaBay
07-12-2006, 09:04 AM
In MS Access, we can compact and repair the database. How do you do it in MS SQL Server 2000?
Thanks.
Thanks.
Compact and repair in SQL server 2000TampaBay 07-12-2006, 09: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, 09: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