re: Tracking Merge Agent Performance using Distribution database system tables

Jayjen — Wed, 23 Jun 2010 16:30:51 GMT

When trying a similar operation we first needed to find suitable table records that contained a url string that we were looking for using a select query like this

SELECT p_descfield

FROM dbo.ProductTable

WHERE p_descfield LIKE '% www.superstoresearch.com %'

Once we narrowed it down to the records that contained data that we wanted to scrape and merge, we were able to hand over only the relevant result set for processing into the next stage of a test script that had been experimenting with.

re: Tracking Merge Agent Performance using Distribution database system tables

wtaylor — Wed, 17 Mar 2010 04:02:38 GMT

Wow! This looks complicated for me but I'll try this. This will be a big help for my business. Thanks! ;-)