USE OCULAR3
GO
--
--BACKUP LOG OCULAR3 WITH NO_LOG
SP_DBOPTION 'OCULAR3','TRUNC. LOG ON CHKPT.','TRUE'
GO
DBCC SHRINKFILE('OCULAR3_LOG',0)
GO
--
DECLARE @COUNT INT
DECLARE @VAR_NAME VARCHAR(255)
DECLARE CUR_TBL CURSOR LOCAL FOR
SELECT [NAME] FROM SYSOBJECTS WHERE XTYPE='U' ORDER BY NAME
SET @COUNT=(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='U' )
PRINT 'Total= '+cast(@count as varchar(100))
set @count=0
OPEN CUR_TBL
FETCH NEXT FROM CUR_TBL INTO @VAR_NAME
WHILE @@FETCH_STATUS = 0
BEGIN
SET @VAR_NAME='['+@VAR_NAME+']'
set @count=@count+1
print cast(@count as varchar)+':'+@var_name
DBCC DBREINDEX(@VAR_NAME)
FETCH NEXT FROM CUR_TBL INTO @VAR_NAME
END
CLOSE CUR_TBL
DEALLOCATE CUR_TBL
--SHRINKDATABASE
--BACKUP LOG OCULAR3 WITH NO_LOG
GO
DBCC SHRINKDATABASE(OCULAR3)
GO
SP_DBOPTION 'OCULAR3','TRUNC. LOG ON CHKPT.','TRUE'
GO
