How to compact & repair database in SQL Server 2000?

Hi All,
You must be knowing that we can compact & repair database in
ACCESS. Is there any way / utility to do the same in SQL Server 2000? (Serve
r
CE does provide this facility)
Regards,
HarshadNo
But you can use DBCC CHECKDB to do consistency check.(which is done by
compact and repair wizard in access)
--
Regards
R.D
--Knowledge gets doubled when shared
"Harshad Phadnis" wrote:

> Hi All,
> You must be knowing that we can compact & repair database in
> ACCESS. Is there any way / utility to do the same in SQL Server 2000? (Ser
ver
> CE does provide this facility)
> Regards,
> Harshad|||As for defrag and compaction, I suggest you check out:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:F1864887-1CAD-4430-A59D-2ADAE4FBE487@.microsoft.com...
> No
> But you can use DBCC CHECKDB to do consistency check.(which is done by
> compact and repair wizard in access)
> --
> Regards
> R.D
> --Knowledge gets doubled when shared
>
> "Harshad Phadnis" wrote:
>