USE Northwind DECLARE tables CURSOR FOR SELECT dbOwnTable = DB_NAME()+'.'+USER_NAME( uid )+'.'+Name FROM sysobjects WHERE type='U' OPEN tables DECLARE @dbOwnTable varchar(400) FETCH NEXT FROM tables INTO @dbOwnTable WHILE @@FETCH_STATUS = 0 BEGIN DBCC DBREINDEX (@dbOwnTable) -- WITH NO_INFOMSGS FETCH NEXT FROM tables INTO @dbOwnTable END CLOSE tables DEALLOCATE tables GO