CREATE PROCEDURE ReIndex_All AS

DECLARE @tablename varchar( 30 )
DECLARE @tablename_header varchar( 75 )
DECLARE tnames_cursor CURSOR FOR SELECT name FROM sysobjects 
	WHERE type = 'U'
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @tablename
WHILE (@@fetch_status <> - 1 )
BEGIN
	IF (@@fetch_status <> - 2 )
	BEGIN
		SELECT @tablename_header = RTRIM(UPPER(@tablename))
		PRINT @tablename_header
		EXEC ( "DBCC DBREINDEX ("  + @tablename + " )" )
	END
	FETCH NEXT FROM tnames_cursor INTO @tablename
END

PRINT  " " 
PRINT  "ReIndex completed for all tables." 
DEALLOCATE tnames_cursor