检查所有表是否有错误

declare @name varchar(100)
declare cur cursor for
select name from sysobjects where xtype=’u’ order by name
open cur
fetch next from cur into @name
while @@fetch_status=0
begin

dbcc checktable(@name)

fetch next from cur into @name
end
close cur
deallocate cur