June 6, 2003 at 4:59 pm
I recently added a new column to an article using sp_repladdcolumn. The columns appeared on the subscriber, they are in the insert/update sprocs yet the data in the publisher is not getting put on the subscriber for these columns.
Where does replication get the information to run the stored procedures and what values to pass to them. Is there anything I can do in the sys tables to ensure these 2 columns get data replicated?
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
June 9, 2003 at 8:00 am
This was removed by the editor as SPAM
June 9, 2003 at 8:59 am
Log reader picks up the data and stuffs into distribution, then distribution agent actually calls the proc that should include the column you added. Hate to ask, but you're sure the updates are happening on the publisher? Tried profiling the subscriber to see if data is coming over but not getting applied correctly?
Andy
June 9, 2003 at 9:03 am
Thanks for the response. Yes there are over 20,000 rows that have been updated for these columns. I have not run profiler. Thanks for the tip. Any thoughts on what the best filter would be? thx.
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
June 9, 2003 at 11:17 am
Well...not really! Maybe just try to filter on the publisher computer name as the hostname. You'll get a lot, but you can filter it afterwards.
Andy
June 9, 2003 at 12:13 pm
Nice work Andy. Running profiler led me to the sp_msupd sproc. The dist agent was passing the correct variables but my sproc was not running appropriately. This is one that I have manually modified to handle identities and primary key settings. When I manually added the columns to the sp, I should have pushed the binary variable from 1 to 2 since we passed the 128 on 1.
I changed the binary variable from binary(1) to binary(2) and that fixed the issue.
Thanks for leading me in the right direction.
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply