问题现象：金蝶kis专业版16.0 登录账套提示 对象名‘ AcctCtl.dbo.t_ad_kdAccount_gl ’无效

找不到对象"AcctCtldbo.t ad BatchAutoBKSettings，因为它不存在或者您没有所需的权限。

IE

COL LENGTH(AcctCtldbo.t ad BatchAutoBKSetting

5"."FPromptWay) IS NULL alter table

AcctCtl.dbo.t ad BatchAutoBKSettings add

FPromptWay bit DEFAULT(O) NOT NULL

 

解决方案：

数据库执行以下脚本 

USE [AcctCtl]

GO

/****** Object:  Table [dbo].[t_ad_BatchAutoBKSettings]    Script Date: 02/18/2025 15:46:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[t_ad_BatchAutoBKSettings](

[FPID] [varchar](50) NOT NULL,

[FHappenDay] [int] NOT NULL,

[FHappenTime] [varchar](50) NOT NULL,

[FIsDel] [bit] NOT NULL,

[FOverDay] [int] NOT NULL,

[FBakDir] [nvarchar](1000) NULL,

[FLastBakTime] [smalldatetime] NULL,

[FSettingTime] [datetime] NULL,

[FPromptWay] [bit] NOT NULL,

PRIMARY KEY CLUSTERED 

(

[FPID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[t_ad_BatchAutoBKSettings] ADD  DEFAULT ((7)) FOR [FHappenDay]

GO

ALTER TABLE [dbo].[t_ad_BatchAutoBKSettings] ADD  DEFAULT ('2:00:00') FOR [FHappenTime]

GO

ALTER TABLE [dbo].[t_ad_BatchAutoBKSettings] ADD  DEFAULT ((0)) FOR [FIsDel]

GO

ALTER TABLE [dbo].[t_ad_BatchAutoBKSettings] ADD  DEFAULT ((7)) FOR [FOverDay]

GO

ALTER TABLE [dbo].[t_ad_BatchAutoBKSettings] ADD  DEFAULT ((0)) FOR [FPromptWay]

GO