Posted by Erland Sommarskog on 04/20/07 22:19

tlyczko (tlyczko@gmail.com) writes:
> Is this command, which I know can be executed on a per-table basis,
> the same as the Rebuild Index Task in the SQL Server Management Studio
> for maintenance tasks??

I would guess the maintenance task uses ALTER INDEX REBUILD which is a
more modern version of DBCC DBREBUILD, at least in terms of syntax.

I have not worked much with maintenance plans, but since they SSIS
packages, you should be able to look what's on the inside with help
of the Business Intelligence Development Studio.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]