SQL SERVER 2000 update data Question

Question

 

In vb6 code, Select the data from the server database on the Local lan, it works well. But when Inserting the data into another table in the same database, the message shows: invalid object name dbo.sysmergearticles. Insertion could not be completed.

Could someone have some suggestions?

Thank you.

Answer 1

Just to check, from the VB code can you select information from that table?

Answer 2

Hi HinF2012,

Could you please post the INSERT statement and a code snippet of your application?

As the error message indicates, the specified table cannot be found. dbo.sysmergearticles is a system table used by SQL Server Replication. Why do you insert rows iinto this system table?

Please check if the table exists in the database and the current login have sufficient permissions.

Reference:

Replication Tables (Transact-SQL)

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.