dynamically building the DBCC command: : DBCC « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. DBCC

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