/***********************
重建数据库表所在有索引
2006-06-12
先选择要修复的数据库
***********************/
DECLARE @name varchar(100)
--所有用户表游标
DECLARE authors_cursor CURSOR FOR
Select [name]
from sysobjects where xtype='u' order by id
OPEN authors_cursor
FETCH NEXT FROM authors_cursor
INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
--修复数据表索引
DBCC DBREINDEX (@name, '', 70)
-- Get the next author.
FETCH NEXT FROM authors_cursor
INTO @name
END