几个老外库都是这问题，服务端换了老外的也不行。莫名其妙，搜索老帖子CT说和数据源有关系。要怎么调整呢？
==================
按照置顶的方法尝试提示这个

服务器: 消息 2812，级别 16，状态 62，行 1
未能找到存储过程 'Account_char'。
服务器: 消息 2714，级别 16，状态 4，行 3
数据库中已存在名为 'PK_ACCOUNT_CHAR' 的对象。
服务器: 消息 1750，级别 16，状态 1，行 3
未能创建约束。请参阅前面的错误信息。

[ 本帖最后由 bwzz 于 2008-11-11 18:57 编辑 ]

以下3个表删除Account_char TB_USER UserData
，然后在查询器里复制运行下就好了，运行按F5

1. Account_char
   
2. 
   
3. CREATE TABLE [ACCOUNT_CHAR] (
   
4. [strAccountID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
   
5. [bNation] [tinyint] NOT NULL ,
   
6. [bCharNum] [tinyint] NOT NULL CONSTRAINT [DF_ACCOUNT_CHAR_bCharNum] DEFAULT (0),
   
7. [strCharID1] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   
8. [strCharID2] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   
9. [strCharID3] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   
10. [strCharID4] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
11. [strCharID5] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
12. CONSTRAINT [PK_ACCOUNT_CHAR] PRIMARY KEY CLUSTERED
    
13. (
    
14. [strAccountID]
    
15. ) WITH FILLFACTOR = 90 ON [PRIMARY]
    
16. ) ON [PRIMARY]
    
17. GO
    
18. 
    
19. ==========================
    
20. TB_USER
    
21. 
    
22. CREATE TABLE [TB_USER] (
    
23. [strAccountID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
24. [strPasswd] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
25. [strSocNo] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
26. [idays] [int] NOT NULL ,
    
27. [strEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
28. [strAuthority] [tinyint] NULL ,
    
29. [IP] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    
30. ) ON [PRIMARY]
    
31. GO
    
32. 
    
33. =============================
    
34. UserData
    
35. 
    
36. CREATE TABLE [USERDATA] (
    
37. [strUserId] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
38. [Nation] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Nation] DEFAULT (0),
    
39. [Race] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Race] DEFAULT (1),
    
40. [Class] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Class] DEFAULT (0),
    
41. [HairColor] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Gender] DEFAULT (0),
    
42. [Rank] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Rank] DEFAULT (0),
    
43. [Title] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Title] DEFAULT (0),
    
44. [Level] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Level] DEFAULT (1),
    
45. [Exp] [int] NOT NULL CONSTRAINT [DF_USERDATA_Exp] DEFAULT (0),
    
46. [Loyalty] [int] NOT NULL CONSTRAINT [DF_USERDATA_Loyalty] DEFAULT (100),
    
47. [Face] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Religion] DEFAULT (0),
    
48. [City] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_City] DEFAULT (0),
    
49. [Knights] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Knights] DEFAULT (0),
    
50. [Fame] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Fame] DEFAULT (0),
    
51. [Hp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Hp] DEFAULT (100),
    
52. [Mp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Mp] DEFAULT (100),
    
53. [Sp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Sp] DEFAULT (100),
    
54. [Strong] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Str] DEFAULT (0),
    
55. [Sta] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Sta] DEFAULT (0),
    
56. [Dex] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Dex] DEFAULT (0),
    
57. [Intel] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Intel] DEFAULT (0),
    
58. [Cha] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Cha] DEFAULT (0),
    
59. [Authority] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Authority] DEFAULT (1),
    
60. [Points] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Points] DEFAULT (0),
    
61. [Gold] [int] NOT NULL CONSTRAINT [DF_USERDATA_Gold] DEFAULT (0),
    
62. [Zone] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Zone] DEFAULT (1),
    
63. [Bind] [smallint] NULL ,
    
64. [PX] [int] NOT NULL CONSTRAINT [DF_USERDATA_PX] DEFAULT (268100),
    
65. [PZ] [int] NOT NULL CONSTRAINT [DF_USERDATA_PZ] DEFAULT (131000),
    
66. [PY] [int] NOT NULL CONSTRAINT [DF_USERDATA_PY] DEFAULT (0),
    
67. [dwTime] [int] NOT NULL CONSTRAINT [DF_USERDATA_dwTime] DEFAULT (0),
    
68. [strSkill] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_USERDATA_strSkill] DEFAULT (0x00),
    
69. [strItem] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
70. [strSerial] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
71. [sQuestCount] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_sQuestCount_1] DEFAULT (0),
    
72. [strQuest] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
73. [MannerPoint] [int] NOT NULL CONSTRAINT [DF_USERDATA_MannerPoint] DEFAULT (0),
    
74. [LoyaltyMonthly] [int] NOT NULL CONSTRAINT [DF_USERDATA_LoyaltyMonthly] DEFAULT (0),
    
75. [CreateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_USERDATA_CreateTime_1] DEFAULT (getdate()),
    
76. [UpdateTime] [smalldatetime] NULL ,
    
77. CONSTRAINT [PK_USERDATA] PRIMARY KEY CLUSTERED
    
78. (
    
79. [strUserId]
    
80. ) WITH FILLFACTOR = 90 ON [PRIMARY]
    
81. ) ON [PRIMARY]
    
82. GO

复制代码

我按照这个做了，提示缺少这三个文件Account_char TB_USER UserData
删除之后还要手动建立？

没找到储存过程
服务器: 消息 2812，级别 16，状态 62，行 1
未能找到存储过程 'Account_char'。
服务器: 消息 2714，级别 16，状态 4，行 3
数据库中已存在名为 'PK_ACCOUNT_CHAR' 的对象。
服务器: 消息 1750，级别 16，状态 1，行 3
未能创建约束。请参阅前面的错误信息。

[ 本帖最后由 bwzz 于 2008-11-11 18:41 编辑 ]

表格问题

那些表有问题呢？

SQL資料表刪除再導入以上數據吧....上面不是儲存過程....