Invalid object name 'sysarticles'.(Microsoft.SqlServer.SmoExtended)

Question

I am trying to do a merge replication , on sql server

Invalid object name 'sysarticles'.
Could not use view or function 'dbo.sysextendedarticlesview' because of binding errors. (.Net SqlClient Data Provider)

and also tried restore the same DB , and got the same error message , may i know what the issue and how can i solve it ?

Answer 1

Similar thread :
https://www.sqlservercentral.com/forums/topic/invalid-object-name-sysarticles-and-availability-groups

Answer 2

Hi @Srikanth Cherupally ,
I 've found a simmliar situation and here is the link https://social.technet.microsoft.com/Forums/en-US/4248f847-d717-4ad0-bd5c-7ac03adc6c21/error-208-invalid-object-name-dbosysextendedarticlesview-deleting-publicationdistribution.I hope it can be a little help.
I also recommemd that you may try this code:
CREATE TABLE [dbo].[sysarticles](
[artid] [int] IDENTITY(1,1) NOT NULL,

If it gets the error that:Msg 208, Level 16, State 1, Procedure sysextendedarticlesview, Line 14 [Batch Start Line 0]
Invalid object name 'sysschemaarticles'.

You can use the following order:
CREATE TABLE [dbo].[sysschemaarticles](
[artid] [int] NOT NULL,
Best regards
Jong

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 3

Hi @Srikanth Cherupally ,
How about the problem? :)