Is there a stored procedure that allow the compact database programmaticall y
in SQL Server?
in SQL Server?
-
-
Re: Compact Database
"Claudio Di Flumeri" <claudioNOSPAM@ mtgc.net> wrote in message
news:c0conk$15i 74v$1@ID-198343.news.uni-berlin.de...[color=blue]
> Is there a stored procedure that allow the compact database[/color]
programmaticall y[color=blue]
> in SQL Server?[/color]
Check documentation for
DBCC SHRINKDATABASE
-
Re: Compact Database
"Claudio Di Flumeri" <claudioNOSPAM@ mtgc.net> wrote in message news:<c0conk$15 i74v$1@ID-198343.news.uni-berlin.de>...[color=blue]
> Is there a stored procedure that allow the compact database programmaticall y
> in SQL Server?[/color]
I believe compacting is an Access concept - it doesn't exist in MSSQL.
If you want to check the integrity of a database, then you can look at
DBCC CHECKDB; if you want to physically reduce the size of a database,
then DBCC SHRINKDATABASE and DBCC SHRINKFILE would help.
Simon
Comment
Comment