Re: TO PAUL IBISON

Brad,

Sorry to peek in, but as Paul mentioned, your problem seems to be filter
related. Sometimes the data is not what it actually looks like. Spaces and
other (hidden) characters can go unnoticed to us, but the queries will see
the difference. This can happen when the data is not validated, as for
example when you bulk import data.

One thing you MUST do before anything else is check that the record matches
your filter criteria (a simple query). If your row does not turn up, then
there is the problem.
Anyway, let us know what the outcome is when finally you pin it down.

Raj Moloye


"Brad M." <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ORsebR9QFHA.2356@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Paul,
>
> I tried the proc that you had on your website, but the comments in the
> proc say it's for pending merge changes on a subscriber - my issue is that
> the row is not getting replicated from the publisher. Do you know how I
> could modify it to show me what I need? Also too, we do indeed have
> filters in our publication, but I checked the data for the row in question
> and it would fall into the criteria to replicate to my test machine.
>
> Any other assistance is greatly appreciated!
>
> Thanks Paul,
> Brad
>
> "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx> wrote in message
> news:%23$xGEJoQFHA.3628@xxxxxxxxxxxxxxxxxxxxxxx
>> Brad,
>> you have done all the things I'd try :) I wouldn't recommend deleting the
>> row in the MSmerge_contents table. Try just doing another dummy update on
>> a single row and see if this goes across. There is a procedure at the top
>> of my merge page which should list the records that should be propagated,
>> and it'd be interesting to see if it turns up there. Also, do you have
>> any filters involved that would stop the rows propagating? Finally, there
>> is only one known issue that I have seen :
>> http://support.microsoft.com/kb/889314. Provided you have a recent patch
>> this is taken out of the equation.
>> Rgds,
>> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
>>
>>
>
>


.

Relevant Pages

  • Re: CUPS redirecting
    ... Paul W. Elsinghorst wrote: ... does someone know if there is a way to redirect pages to another printer ... What you need to do is make a new queue and specify some basic script stub as a filter..it used to be that a filter was something that got the print stream and spa it to stdout..now it doesn't have to do that..it can dump it in a file, call another print q and exit with 'done' ... Of course the user level monitoring of print queues gets a tad messy.. ...
    (comp.os.linux.misc)
  • Re: Get variable from UI
    ... Thanks for your advice Paul. ... and with the encryption cipher option to be passed ... When you say send a message to the filter, ... to the registry and then, if dynamic changes are required, send a ...
    (microsoft.public.windowsce.platbuilder)
  • Re: 1.5" of pipe-cleaner in the Mortise
    ... if you smoke like paul szabady, you always get a great smoke. ... filters and half of the pipes are made with 9mm filter bores. ...
    (alt.smokers.pipes)
  • RE: Formula on nth row
    ... if you have a header row make it ... Filter on the TRUE values ... Press the F5 key, click on Special, and select Visible Cells Only ... "Paul" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Additional Domain Controller
    ... Global Catalog.Now i want to prepare second DC which real time replicate all ... Thanks again Paul. ... you should have at least TWO DCs per domain. ... >>> If you use a multiple domain model, users, Groups, computers and GPOs ...
    (microsoft.public.windows.server.active_directory)