- 论坛徽章:
- 1
|
1> use master
2> go
1> sp_dboption database_name, "single user", true
2> go
1> sp_configure "allow updates", 1
2> go
Issue the sp_fixindex command:
1> use database_name
2> go
1> checkpoint
2> go
1> sp_fixindex database_name, object_name, index_ID
2> go
Run dbcc checktable to verify that the corrupted index is now fixed.
Disallow updates to system tables:
1> use master
2> go
1> sp_configure "allow updates", 0
2> go
Turn off single-user mode:
1> sp_dboption database_name, "single user", false
2> go
1> use database_name
2> go
1> checkpoint
2> go
不知道可不可以帮到你。。
解决后告诉大家一下。 |
|