September 11, 2008 at 11:36 pm
We have a SQL 2005 Merge publication pushing out to 2 subscribers. All servers are running SQL 2005 Std, the publisher is 32bit and the subscribers 64
One of the subscribers has stopped replicating reporting the error message:
The merge process could not retrieve column information for table 'dbo.CS_SourcePermission'. Verify that you have sufficient privileges on the database and retry the operation. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201016)
The other subscriber is fine, and no changes where made to the table in question. Re-initialized the subscription and pushed that out with a new snapshot, but still got the error
Replication moitor also shows these two errors:
Incorrect syntax near '/'. (Source: MSSQLServer, Error number: 102)
Get help: http://help/102
Unclosed quotation mark after the character string '> <!--MSmerge_sel_sp_B17AD670785242A51E7B119871A94007 @maxschemaguidforarticle = NULL, @type = 6 '. (Source: MSSQLServer, Error number: 105)
Get help: http://help/105
Any ideas on what to do or where to look?
September 11, 2008 at 11:54 pm
Hello,
Has your Merge Replication been in place for a while? In which case does this thread relate to your issue (it is SQL 2000 related though):
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
September 12, 2008 at 12:03 am
Hi,
Replication had been in place for about a year.
Had to delete the subscription and recreate it the other day due to some problems, was working fine until about 4:00 PM yesterday.
I've just changed the agent to use Windows Auth and a different SQL user, re-initialised and told it not to upload changes, appears to be applying the schema, so I'll see how it goes
I'll also have a look at that thread and see what that has to say
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply