DECLARE@DBCCStringNVARCHAR(1000)DECLARE@TableNameVARCHAR(100)DECLARECur_IndexCURSORFORSELECTNameASTblNameFROMsysobjectsWHERExType='U'ORDERBYTblNameFORREADONLYOPENCur_IndexFETCHNEXTFROMCur_IndexINTO@TableNameWHILE@@FETCH_STATUS=0BEGINPRINT'重建表'+@TableName+'的索引........Start!'SET@DBCCString='DBCCDBREINDEX(@TblName,'''')WITHNO_INFOMSGS'EXECSP_EXECUTESQL@DBCCString,N'@TblNameVARCHAR(100)',@TableNamePRINT'重建表'+@TableName+'的索引........END!'FETCHNEXTFROMCur_IndexINTO@TableNameEND
