Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation

From Wiki_dbSQWare
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


Rebuild indexes for all databases
version = 2000 -> Dbcc dbreindex (N'[$lvsqw_Owner].[$lvsqw_TableName]',,90)
version >= 2005 -> alter index all on [$lvsqw_Owner].[$lvsqw_TableName] Rebuild with (online = off)

Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwmsq_RebuildIndexDatabase.ksh_presentation&oldid=30595"