怎样修复 数据库索引
DECLA RE @name varchar 100
-- 所有用户表游标
DECLA RE authors_cursor CURSOR FOR
Select [name]
from sysobject where xtype='u' order by id
OPEN authors_cursor
FETCH NEXT FROM authors_cursor
INTO @name
WHILE @@FETCH_STA TUS = 0
BEGIN
-- 修复数据表索引
'', DBCC DBREINDEX @name. 70
-- Get the next author.
FETCH NEXT FROM authors_cursor
INTO @name
END
转载请标明出处: http://blog.csdn.net/pomood_opp999 本文来自 CSDN 博客。x