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??

The documentation I have mentions the reindex.sql script, is this the
script that is executed by the Rebuild Index Task??

Thank you, Tom

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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx