我在检查数据库:
得到如下错误:
Msg 1505, Level 16, State 1, Line 5
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.a_AppHeader_0426' and the index name 'PK_a_AppHeader'. The duplicate key value is (TT08-00407).
Msg 1505, Level 16, State 1, Line 5
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.a_ChecklistDetails' and the index name 'PK_a_ChecklistDetails'. The duplicate key value is (TT08-00381 , 00381, 5, 10).但我表中 "TT08-00407" 中只有一条记录。请问是什么原因??
得到如下错误:
Msg 1505, Level 16, State 1, Line 5
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.a_AppHeader_0426' and the index name 'PK_a_AppHeader'. The duplicate key value is (TT08-00407).
Msg 1505, Level 16, State 1, Line 5
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.a_ChecklistDetails' and the index name 'PK_a_ChecklistDetails'. The duplicate key value is (TT08-00381 , 00381, 5, 10).但我表中 "TT08-00407" 中只有一条记录。请问是什么原因??
解决方案 »
- 这个的功能应该怎么实现?
- sql的表结构问题
- sql 2005 EXECUTE 的权限问题
- “update 表 set 字段='' where 1=2”这个语句锁表不行。请高手帮忙
- 请问如何在让Instead of update 触发器执行update原本的功能?
- 存储过程中的参数使用,高手请入(高手请入),up有份
- 关于复制文本
- 如何在客户端的电脑上利用SQL语句把服务器的数据库备份到客户端的电脑上?
- 请各位帮忙优化一下这个查询语句
- 触发器问题,update一个字段,把update前数据放到另一个字段,如何做?
- 为什么自定义函数的参数为"0"带头的话,会过去就不带"0"了呢?
- 存储过程执行出错
dbcc checkdb('',REPAIR_allow_data_loss)
dbcc checkdb('',REPAIR_REBUILD)得到的错误1