Paul never mind!

I was just informed that we wont be doing the
initialization this way. I was told that I would be
allowed to generate a new snapshot/ repopulate the
reporting server when this launches and that decision was
just changed. Therefore, I need to totally re-do my whole
setup. Im so sorry for any inconvenience this may have
caused you. My apologies.
ChrisR

>--Original Message--
>Chris,
>I used your script and after running
sp_refreshsubscriptions everything
>worked ok. Spaces get created between letters if I use
native format, but
>just to check if this was a problem, I tried once with
native and once with
>character format and both worked fine. I added the stored
procedure to the
>subscriber by hand, but apart from that it was all the
same. Can you try
>without the stored proc and use native format, just to
check that the bcp is
>the same style as the one you are used to? If this still
errors, please can
>you export some data to a csv file and post it up, just
so I am using more
>or less the same data.
>TIA,
>Paul Ibison
>
>.
>
No worries Chris.
I'll still have a play around with the data and see if I can repro this out
of interest.
Cheers,
Paul Ibison
|||My deal was that I was being a real bonehead and needed to modify the insert
stored proc to accomodate for the different schema. I knew they had
different schemas and had a Custom Sync View on the Publisher. But theres no
way that could have helped to insert data into the Subscriber.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23uP%23OkDhEHA.3016@.tk2msftngp13.phx.gbl...
> No worries Chris.
> I'll still have a play around with the data and see if I can repro this
out
> of interest.
> Cheers,
> Paul Ibison
>