错误:SQL Server报”对象名 ‘sysproperties’ 无效”的错误的解决办法
处理:缺sysproperties系统表导致
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
CREATE TABLE [dbo].[sysarticles] (
[artid] int IDENTITY(1,1) NOT NULL,
[creation_script] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[del_cmd] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[description] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[dest_table] sysname NOT NULL,
[filter] int NOT NULL,
[filter_clause] ntext COLLATE Chinese_PRC_CI_AS NULL,
[ins_cmd] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[name] sysname NOT NULL,
[objid] int NOT NULL,
[pubid] int NOT NULL,
[pre_creation_cmd] tinyint NOT NULL,
[status] tinyint NOT NULL,
[sync_objid] int NOT NULL,
[type] tinyint NOT NULL,
[upd_cmd] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[schema_option] binary(8) NULL,
[dest_owner] sysname NULL,
[ins_scripting_proc] int NULL,
[del_scripting_proc] int NULL,
[upd_scripting_proc] int NULL,
[custom_script] nvarchar(2048) COLLATE Chinese_PRC_CI_AS NULL,
[fire_triggers_on_snapshot] bit DEFAULT ((0)) NOT NULL
)
GO
ALTER TABLE [dbo].[sysarticles] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Auto increment value for sysarticles
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sysarticles]', RESEED, 1)
GO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE TABLE [dbo].[sysschemaarticles] (
[artid] int NOT NULL,
[creation_script] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[description] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[dest_object] sysname NOT NULL,
[name] sysname NOT NULL,
[objid] int NOT NULL,
[pubid] int NOT NULL,
[pre_creation_cmd] tinyint NOT NULL,
[status] int NOT NULL,
[type] tinyint NOT NULL,
[schema_option] binary(8) NULL,
[dest_owner] sysname NULL
)
GO
ALTER TABLE [dbo].[sysschemaarticles] SET (LOCK_ESCALATION = TABLE)
GO