【问】上传日志时提示“上传日志信息失败”,如何解决? | ||
【适用版本】商业之星7 | 【模块】基本档案 | 【点击数】75 |
【知识编号】P2017121300003 | ||
【问题描述】打开前台提示:上传日志信息失败!!! |
备份数据库执行:
–修复自增列语句:
use hbposv7 —-分店改为hbposv7_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 hbposv7 —-分店改为hbposv7_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