March 23, 2003 at 7:47 pm
Well I'll be hacking in trying to fix this, but wondering if anyone else has run into this and maybe has a better proper fix.
I have a DB that is the subscriber to many Pull subs, and then the Publisher to one.
One table was really badly designed, I won't name the designer but his initials are KlK, so I decided to fix it.
Delete the table, may have even dropped replication, etc.
When I recreate the table, with the same name, and a better structure. The original Replication SPs still exist. They weren't eliminated when the table was dropped (Shame on you MS), and were not recreated when the new table was reactivated for publication / replication.
So the SP refers to all of the original field names.
I can't whack the DB.
My plan is to somehow build this elsewhere, and transfer the SPs for this table.
KlK, MCSE
KlK
March 24, 2003 at 6:17 am
You could re create the publication in another server, so when you apply the snapshot generate the sp again, or also execute the stored procedure:
sp_scriptpublicationcustomprocs 'PublicationName'
You must have Service Pack 1.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply