Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Dynamically building the DBCC command

DECLARE @TableName varchar(255)    DECLARE TableCursor CURSOR FOR       SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES          WHERE TABLE_TYPE = 'BASE TABLE'    DECLARE @Command varchar(255)    OPEN TableCursor    FETCH NEXT FROM TableCursor INTO @TableName    WHILE @@FETCH_STATUS = 0    BEGIN       PRINT 'Reindexing ' + @TableName       DBCC DBREINDEX(@TableName)       FETCH NEXT FROM TableCursor INTO @TableName    END    CLOSE TableCursor    DEALLOCATE TableCursor    GO