I am trying to get replication configured on SQL 2008 and am getting a very random error.
I had 2 SQL 2005 instances (A and B) that replicated (transactional) 2 databases (db1 and db2). I have done a side by side install of SQL 2008 (2 instances C and D) and transferred (backup/restore) the databases to SQL 2008 on instance C.
I have replicated db1 to instance D with no errors or warnings.
When I try to replicated any part of db2 I get and error saying:
this happens regardless of instance A being started or not.Does anyone have any suggestions on how this might be resolved? Creating a script from the replication GUI leads to a ms_repl_somethingorother that has the error but I cannot locate this procedure in any database, on any instance.
asked Aug 09, 2010 at 05:09 AM in Default