The following script reindexes all tables in the current database:

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