We started replication on the hq database and are getting errors when we run the 401's on the customer and shipto tables. It seems to be picking up the replication column.
Invalid column name 'msrepl_trn_version'
anyone been succesfull with replication. any help would be greatly appreciated thanks
hi Markd, Don't mind but if you have done this in live enviornment then it is worng, first of all no where it is written that it support the replication technology, I know i have put the replication script on the newsgroup for the store operation only becuase I have been using it for last 3 years and it is satifying my needs. basically atleast helping me backup my stores database to server without using HQ and then I created the tool to integrated with GP.
But always remember never do before you test first the complete cycle of it. I suggest you to do use the SQL profiler this will help you and check what has been sending to the hq server once 401 is process. then you can judge that what is going wrong.
I belive once you setup the distributor, publisher, subscriber then the next step is to generate the snapshop at HQ and then to all subscriber replicate, this will create columns at store level also and later you can process the
401. H> We started replication on the hq database and are getting errors when we run
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.