Încearcă aşa:

--CREATE TABLE [NR.1] (X INT)

DECLARE @TABLE_NAME nvarchar(517)
DECLARE CRS_TABLENAME CURSOR LOCAL READ_ONLY FOR
SELECT QUOTENAME(SCHEMA_NAME(schema_id))+'.'+QUOTENAME(name) FROM sys.tables -- pentru SQL 2005 sau ulterior
--SELECT QUOTENAME(USER_NAME(uid))+'.'+QUOTENAME([NAME]) FROM SYSOBJECTS WHERE XTYPE = 'U' -- doar pentru SQL 2000 sau mai vechi
OPEN CRS_TABLENAME

WHILE 1=1 BEGIN
FETCH NEXT FROM CRS_TABLENAME INTO @TABLE_NAME
IF @@FETCH_STATUS <> 0 BREAK
PRINT @TABLE_NAME
DBCC DBREINDEX(@TABLE_NAME,'',0)
END

CLOSE CRS_TABLENAME
DEALLOCATE CRS_TABLENAME

Răzvan