DECLARE @SQLStatement nvarchar(4000)
--DECLARE TableList CURSOR LOCAL FAST_FORWARD READ_ONLY  FOR

Declare @tmpReindexList table (SeqNo int identity(1,1) not null, SQLStatement nvarchar(4000) not null)

insert into @tmpReindexList (SQLStatement) 
SELECT

	N'DBCC DBREINDEX (''['+ db_name() + '].' +
    QUOTENAME(TABLE_SCHEMA) +
    N'.' +
    QUOTENAME(TABLE_NAME)
	 + ''')' as SQLStatement

FROM
    INFORMATION_SCHEMA.TABLES
WHERE EXISTS
    (
    SELECT *
    FROM sysindexes
    WHERE id =
        OBJECT_ID(QUOTENAME(TABLE_SCHEMA) +
        N'.' +
        QUOTENAME(TABLE_NAME)) 
	AND
        indid IN(0,1) 
    )
ORDER BY 1

-- OPEN TableList
declare @SeqNo int
WHILE 1 = 1
BEGIN
    --FETCH NEXT FROM TableList INTO @TableName
	Select top 1 @SeqNo = SeqNo, @SQLStatement=SQLStatement
	from @tmpReindexList
    if @@rowcount = 0 break

	print @SQLStatement

	EXEC(@SQLStatement)

             delete from @tmpReindexList where SeqNo = @SeqNo

END
-- CLOSE TableList
-- DEALLOCATE TableList

exec sp_updatestats

dbcc updateusage(0) with count_rows

     Jul 13  

Sometimes this is me