Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

Dbcc DbReindex

DBCC DBREINDEX in fututre version is an option Rebuild in ALTER INDEX.

Microsoft SQL Server 2000:

DBCC DBREINDEX(<table_name>) WITH NO_INFOMSGS

Microsoft SQL Server 2008:

ALTER INDEX ALL ON <table_name> REBUILD

Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

sqlways/sql-server/upgrade/statementssyntax/dbreindex.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement