August 26, 2003 at 4:42 pm
I created a transactional replication in SQL2000.
I decided not to create a snapshot of the schema and data because the database in very big and it is already in the subscriber. I restored a backup of the db in the subscriber.
After creating the publication and then the subscription with a push I started the synchronization.
As a result I get the following error: Could not find stored procedure find sp_MSins_<Table_Name>.
Anyone has seen this before? How can I work this around?
August 26, 2003 at 7:08 pm
There is a proc that will create the replication procs for you - I apologize for not having the name handy. If no posts it I will look for it tomorrow. A work around for now is to snapshot the db anyway, either to the real subscriber or to a temp one - if you do the temp one then you can script out the objects from there.
Andy
August 27, 2003 at 5:50 am
You can use this on the publication database to create the stored procedures that you can then apply to the subscribing database:
exec sp_scriptpublicationcustomprocs @publication = 'xxxxxx'
August 27, 2003 at 12:18 pm
I tried executing sp_scriptpublicationcustomprocs but I get an error that the sp cannot be found. I am not using SQL Server Ent. version. Is this a problem? The publication is on XP Pro and the subscriber XP Home.
August 27, 2003 at 12:18 pm
I tried executing sp_scriptpublicationcustomprocs but I get an error that the sp cannot be found. I am not using SQL Server Ent. version. Is this a problem? The publication is on XP Pro and the subscriber XP Home.
August 27, 2003 at 12:26 pm
I know this works on SQL Server 2000 running under Windows 2000. You need to specify the exact publication name where I placed the X's and execute it on the publishing database. That should create a script that you can copy and run on the subscribing database.
Sorry but, I do not have any experience with XP so I don't know if it will work there. Hopefully, someone else out there can join in on this thread.
August 27, 2003 at 12:27 pm
I forgot to mention that I am running SQL Server Standard Edition.
August 27, 2003 at 6:09 pm
Ok. It is good to know that it should work in Std ed. I will start the process from the beginning and i'll let you know.
thanks for the help
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply