I ran in to a strange problem yesterday that I still haven't resolved. I moved a replicated database from a SQL 2000 server to a 2008 server using backup/restore and when doing the restore I used the restore wizard (didn't have my script library available)
and I checked the "preserve replication setting" (WITH KEEP_REPLICATION) checkbox without the distributor being configured first. This was obviously a mistake on my part and nothing worked as I had hoped. I then removed all replication related stuff using
the "Disable distribution and publishing"-wizard and everything was removed, including the publications that came with the old database that I restored. As far as I know I was back to a cleen slate.
Then I configured the distributor again without a hitch but when I tried to create the publication I got a weird error. I had scripted the creation of the publication and when running the exec sp_addpublication I got the following error:
Msg 2812, Level 16, State 62, Procedure sp_MSrepl_addpublication, Line 1357
Could not find stored procedure '.
Has anyone seen this before...? I've searched both this site and googled but can't seem to find anything. The database is not mirrored and the database is SQL 2008 SP1 Standard.
View Complete Post