- DECLARE @ST Nvarchar(300),@Name Nvarchar(50),@Table Nvarchar(50), @Db Nvarchar(50)
-
- SELECT @Db=Db_Name()
-
- DECLARE CUR CURSOR FOR (SELECT I.Name, S.Name TableName FROM SYSIndexes I Inner join SysObjects S ON I.Id = S.Id Inner Join SysObjects Si ON I.Name=Si.Name WHERE S.Xtype='U')
-
- OPEN CUR
-
- FETCH NEXT FROM CUR INTO @Name,@Table
-
- WHILE @@FETCH_STATUS=0
-
- BEGIN
-
- DBCC INDEXDEFRAG(@Db,@Table,@Name)
-
- FETCH NEXT FROM CUR INTO @Name,@Table
-
- END
-
- CLOSE CUR DEALLOCATE CUR
DECLARE @ST Nvarchar(300),@Name Nvarchar(50),@Table Nvarchar(50), @Db Nvarchar(50)
SELECT @Db=Db_Name()
DECLARE CUR CURSOR FOR (SELECT I.Name, S.Name TableName FROM SYSIndexes I Inner join SysObjects S ON I.Id = S.Id Inner Join SysObjects Si ON I.Name=Si.Name WHERE S.Xtype='U')
OPEN CUR
FETCH NEXT FROM CUR INTO @Name,@Table
WHILE @@FETCH_STATUS=0
BEGIN
DBCC INDEXDEFRAG(@Db,@Table,@Name)
FETCH NEXT FROM CUR INTO @Name,@Table
END
CLOSE CUR DEALLOCATE CUR