进前台时提示已达到最大错误数(8000商海通、QPOS)

在查询分析器里选择 百威帐套 ，执行：
drop table pos_t_operator_log
go
CREATE TABLE [pos_t_operator_log] (
 [flow_no] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
 [oper_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
 [oper_date] [datetime] NULL ,
 [power_man] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
 [net_type] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__pos_t_ope__net_t__618671AF] DEFAULT ('1'),
 [oper_type] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
 [sheet_no] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
 [jh] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
 [oper_txt] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
 CONSTRAINT [pos_t_operator_log_PK] PRIMARY KEY  CLUSTERED
 (
  [flow_no]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO
delete from pos_t_sale_detail where sheet_no not in (select sheet_no from pos_t_sale_master)
delete from pos_t_sale_pay where sheet_no not in (select sheet_no from pos_t_sale_master)
delete from pos_t_sale_master where sheet_no not in (select sheet_no from pos_t_sale_detail)
go
 declare @table_id varchar(100) ,
  @sql  nvarchar(500)
 declare get_table cursor for
  select name from sysobjects where xtype = 'U' and name not in ('dtproperties', 'pbcatcol',
   'pbcatedt', 'pbcatfmt', 'pbcattbl', 'pbcatvld','坏表1','坏表2','坏表3...')  order by name
 open get_table
 fetch get_table into @table_id
 while @@fetch_status = 0
 begin
   print '正在处理表：'+@table_id
  select @sql = 'DBCC DBREINDEX (' + @table_id + ', ' + char(39) + char(39) + ')'
  execute sp_executesql @sql
  fetch get_table into @table_id
 end
 deallocate get_table

如果执行上面的语句还不可以，前台再解压pos_data.rar 试试。