首先确保你的数据库中同时存在表MEMB_INFO 和Character 如果以上这2个表在不同数据库中，你可以考虑合并数据库后，修改你原来正常使用的数据源，并指向合并后的库。
首先，我们改变 1 memb__pwd varchar 10 0
此主题相关图片如下：
然后，由于新数据库没有了收费表的问题。我们要执行以下sql角本来建立那几个收费表。
注意：打开SQL查询分析器后，在里面我们要选择数据库 muonline 执行以下角本。
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_CURR_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_CURR_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_FQNW_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_FQNW_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_LEAV_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_LEAV_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_MIDS_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_MIDS_INFO]
GO
CREATE TABLE [dbo].[VI_CURR_INFO] (
[ends_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[used_time] [int] NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Bill_Section] [int] NULL ,
[Bill_Value] [int] NULL ,
[Bill_Hour] [int] NULL ,
[Surplus_Point] [int] NULL ,
[Surplus_Minute] [datetime] NULL ,
[Increase_Days] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_FQNW_INFO] (
[appl_code] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctrl_text] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_ques] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fpas_answ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[fanw_guid] [int] NOT NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_LEAV_INFO] (
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctrl_text] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[appl_code] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[leav_guid] [int] NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[memb_mail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[dist_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[prss_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[tel__numb] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_MIDS_INFO] (
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[prev_info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[modi_info] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mids_guid] [int] NOT NULL ,
[admin_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Bill_Section]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Bill_Section]
GO
CREATE TABLE [dbo].[T_Bill_Section] (
[Bill_Start_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_End_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
最后是换为原来的JS－JoinServer 或者用去掉加密的新版JoinServer都可以！
