script_reindex

DELETE scripts
WHERE name = 'script_reindex'
GO
INSERT scripts 
VALUES('script_reindex','DECLARE @objectname varchar(30),')
INSERT scripts 
VALUES('script_reindex','        @CMD varchar(255)')
INSERT scripts 
VALUES('script_reindex','SET NOCOUNT ON') 
INSERT scripts 
VALUES('script_reindex','DECLARE object_cursor CURSOR')
INSERT scripts 
VALUES('script_reindex','FOR')
INSERT scripts 
VALUES('script_reindex','SELECT name FROM sysobjects') 
INSERT scripts 
VALUES('script_reindex','WHERE type = "U"')
INSERT scripts 
VALUES('script_reindex','ORDER BY name')
INSERT scripts 
VALUES('script_reindex','OPEN object_cursor')
INSERT scripts 
VALUES('script_reindex','FETCH NEXT FROM object_cursor INTO @objectname')
INSERT scripts 
VALUES('script_reindex','WHILE (@@fetch_status <> -1)')
INSERT scripts 
VALUES('script_reindex','  BEGIN')
INSERT scripts 
VALUES('script_reindex','    PRINT @objectname')
INSERT scripts 
VALUES('script_reindex','    SELECT @CMD = "DBCC DBREINDEX (" + @objectname') 
INSERT scripts 
VALUES('script_reindex','             + "," + CHAR(39) + SPACE(1) + CHAR(39)')
INSERT scripts 
VALUES('script_reindex','             + ", 90, SORTED_DATA_REORG)"')
INSERT scripts 
VALUES('script_reindex','    EXECUTE (@CMD)')
INSERT scripts 
VALUES('script_reindex','    FETCH NEXT FROM object_cursor INTO @objectname')
INSERT scripts 
VALUES('script_reindex','  END')
INSERT scripts 
VALUES('script_reindex','PRINT " "')
INSERT scripts 
VALUES('script_reindex','PRINT "All objects processed."')
INSERT scripts 
VALUES('script_reindex','CLOSE object_cursor')
INSERT scripts 
VALUES('script_reindex','DEALLOCATE object_cursor')