运行以下命令报错:
alter table task20210528_test add flag_1 int
Msg 208, Level 16, State 1, Procedure sysextendedarticlesview, Line 8 [Batch Start Line 0]
Invalid object name 'sysarticles'.
经检查,Replication下无此库,但是报错原因还是和Replication 相关,
sp_removedbreplication XX
继续报错。。。
从其他建立了Replication的库里面拷贝下缺失表schema:
CREATE TABLE [dbo].[sysarticles](
[artid] [int] IDENTITY(1,1) NOT NULL,
............
再次运行,新的错误:
Msg 208, Level 16, State 1, Procedure sysextendedarticlesview, Line 14 [Batch Start Line 0]
Invalid object name 'sysschemaarticles'.
从其他建立了Replication的库里面拷贝下缺失表schema:
CREATE TABLE [dbo].[sysschemaarticles](
[artid] [int] NOT NULL,
Bingo,解决~