Monday, February 20, 2012 10:39 PM
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?
Tuesday, February 21, 2012 6:59 AMJust to check, from the VB code can you select information from that table?
Wednesday, February 22, 2012 7:31 AM
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.
- Marked As Answer by KJian_ Monday, February 27, 2012 5:37 AM