Return
-
Title
What is the native procedure/command used in LiteSpeed's maintenance plan rebuild index task? -
Description
What is the native procedure or command being called by the Rebuild Index task when creating a LiteSpeed maintenance plan?
-
Resolution
LiteSpeeds maintenance plan Rebuild Index task calls the appropriate SQL Server Integration Services (SSIS) or native maintenance plan executable/DLLs. The Rebuild Index Task uses the ALTER INDEX statement when connected to SQL Server 2005, and the DBCC DBREINDEX statement when connected to SQL Server 2000.
-
Additional Information
More information regarding Rebuild Index, see: http://msdn.microsoft.com/en-us/library/ms189858(v=sql.90).aspx