请按照以下步骤核实处理:
1、重启sql服务后测试。
2、请先备份前台安装目录,之后删除安装目录下的log文件和localdate下的log文件,之后重新打开软件,若依旧不行则说明前台文件有损坏,需要重新安装客户端,卸载客户端删除安装目录和C:\Program Files (x86)\InstallShield Installation Information下的文件,重新安装客户端到其他盘符测试。
3、请尝试修复数据库索引自增列后测试:
备份数据库执行:
--修复自增列语句:
use hbposv8 ----分店改为hbposv8_branch
go
declare @tablename varchar(100)
declare test_cur cursor for
select object_name(id) from syscolumns
where status=128
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin
DBCC CHECKIDENT (@tablename, RESEED)
fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go
---修复索引
use hbposv8 ----分店改为hbposv8_branch
go
declare @tablename varchar(100)
declare test_cur cursor for
select object_name(id) from sysobjects
where type ='U'
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin
DBCC DBREINDEX(@tablename)
fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go