How to add online indexing feature in a job for tables with indexes where theoperations cannot be done online?
SQL Server Restriction
WORKAROUND:
None. The tables with indexes, where theoperations cannot be done online are restricted by SQL Server.The operations must bedone offline.This is not a restriction or function of LiteSpeed.
http://technet.microsoft.com/en-us/library/cc966402.aspx
Online and offline indexing
http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://msdn.microsoft.com/en-us/library/ms190981.aspx
Questions about this process:
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e6c0f374-5b23-4301-96d3-67afb358f3cb
