Compact AND Repair For MSSQL

[vplag]

dear gurus,

how i can make comapct and repair in MSSQL. (the same activity that comapct and repair does in access)

Thanks

VPlag

[hspc]

Check DBCC SHRINKDATABASE , DBCC SHRINKFILE Commands for compacting
and DBCC CHECKDB fro repairing..